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