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 ]