'Microsoft SQL Server Management Studio Permissions
Our software requires the business users (of the software) to have read and write access to the database (MS SQL Server). The users are added to an active directory group with this SQL permission. The business users also want to query the database as read only in SQL Server Management Studio. Is there a way that the user can have read write access to the database from the software and read only from the back end in SQL Server Management studio?
Solution 1:[1]
As the SQL server permissions are assigned to the Active Directory group, the users in the group will be able to have the same permissions irrespective of from where they are accessing the database (from the software or MS SQL server management studio)
The permissions cannot be changed based on from where the users are accessing the database
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | RamaraoAdapa-MT |