Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 16 Apr 2008 @ 15:45:29 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Extra security elements
From:   Tewksbury, Kevin


You are correct about the STARTUP option, as we ran into the same issue. What we have is a script that generates a "revoke logon on all from "user";" for all users that have not logged in the past 60 days and also put that id in a table to keep track of. Then if we have a user that is revoked and has not logged on for 90 days (30 more days since revoked) then we delete them from the system. We actually run this process once a month. Hope this helps! Have to love Sarbanes-Oxley!


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016