How to revoke logon from all but a user

Database
N/A

How to revoke logon from all but a user

Hello,

After a system expansion, we would like to revoke the logon of the users, but not the data loader ID. How is this done?

Thanks for your time,

Linda
1 REPLY

Re: How to revoke logon from all but a user

You should be able to script something using the DBC.Users view to build the REVOKE LOGON FROM /ALL;

It should be noted that you may increase the size of your DBC.LogOnRules.