Link to home
Start Free TrialLog in
Avatar of cheryl9063
cheryl9063Flag for United States of America

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 ]

Open in new window

Avatar of kenwagers
kenwagers
Flag of United States of America image

For example, where the specific table is called 'tablename':

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.
Avatar of cheryl9063

ASKER

I want to use Deny Permissions on a database to a role..
ASKER CERTIFIED SOLUTION
Avatar of kenwagers
kenwagers
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial