All Forums Database
17 Mar 2013

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??

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.

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

You must sign in to leave a comment.