cheryl9063
asked on
deny permissions to role
I want to use the Deny Permission on Role but I need help with the synatx.. Example: my role is called testrole and there are 100 users who have that role..That role gives select permission on 20 different views and several tables.. The database is called Test.. Using my names, how do I write this? I definetly want to use DENY Permission On Role..
DENY permission | ALL [ PRIVILEGES ] [,...n ]
[ON USER::user | ON ROLE::role | ON APPLICATION ROLE::role]
TO principal [ ,...n ] [CASCADE]
[AS principal ]
ASKER
I want to use Deny Permissions on a database to a role..
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, INSERT, DELETE, UPDATE ON tablename TO testrole
or
DENY ALL ON tablename TO testrole
You can put in any combination of the four roles (SELECT, INSERT, DELETE, UPDATE) above.