Deny Permissions On Multiple Roles in SQL
Below is the correct syntax to deny permissions on a role in a SQL Server database. How do you deny permissions to several roles.. Lets say the role names are: Role1, Role2 and Role 3
use Testdb;
DENY SELECT on database:: testdb
to Role1;
go
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
DENY SELECT on database:: testdb to Role1;
DENY SELECT on database:: testdb to Role2;
etc