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

LVL 1
cheryl9063Asked:
Who is Participating?
 
kenwagersConnect With a Mentor Commented:
Ah, I misunderstood.

The easiest way might be to simply not give those users access to the database at all.  But here's some code that will the DENY I think you're looking for.

DENY SELECT TO <role>

You can use other keywords in the place of SELECT.
0
 
kenwagersCommented:
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.
0
 
cheryl9063Author Commented:
I want to use Deny Permissions on a database to a role..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.