SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> |
About Greg: https://about.me/greg.low
From: Tom P
Sent: Thursday, 8 December 2022 10:53 AM
To: Dr Greg Low
Cc: ozDotNet
Subject: Re: [OT] Creating logins/users/roles/permissions in Visual Studio
sqlproj pr
Thanks for the advice, Greg.
Unfortunately, the setup is "legacy" using SQL logins and AD auth is not an
option here. Deployment strategies are currently being investigated but it
looks like they may be going with the old TFS pipelines. I guess the actual
logins and assignment to roles would need
Hi Tom,
For roles and permissions, they should just go directly in the DB projects.
Nothing special about them.
Users/logins are different.
Ideally, you’d have AD or AAD based groups that are added to the roles, and
again they can go right in the project. If you’re looking after the DB or
dep