How to revoke logon from all but a user
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


How to revoke logon from all but a user Expand / Collapse
Author
Message
Posted 6/3/2009 10:12:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 6/30/2009 4:32:07 PM
Posts: 8, Visits: 15
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
Post #15636
Posted 6/11/2009 12:06:08 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 7/29/2009 9:23:21 AM
Posts: 27, Visits: 34
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.
Post #15759
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 2:45pm

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.094. 10 queries. Compression Disabled.