All Forums Database
17 Mar 2013
GRANT/REVOKE LOGON TO ROLE ?

Hello.
When the loading processes start I have to disable logon to users, and when the last process ends I have to enable logons.
I'm doing this with a Revoke Logon on all to user_x, and then grant logon on all to user_x;
what I want to know is if I can do this at role level
that way instead of running 50 sentences I would only have to run one sentence like this:  revoke logon on all to role_x;
is this possible??
 
thanks
 

Adeel Chaudhry 773 posts Joined 04/08
17 Mar 2013

GRANT/REVOKE LOGON only takes user as an input, not the role. May be you can package the commands in a script for ease of use.
 
HTH!

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.