GRANT/REVOKE LOGON TO ROLE ?

Database
Teradata Employee

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

1 REPLY
Teradata Employee

Re: GRANT/REVOKE LOGON TO ROLE ?

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!