Pete Finnigan's Oracle Security Forum


    
      
        Pete Finnigan's Oracle Security Forum
        (http://www.petefinnigan.com/forum/yabb/YaBB.cgi)
      

        Oracle Security >> Oracle Security >> Automatically disable inactive account
        
(Message started by: Pete Finnigan on Sep 10^th, 2007, 4:08pm)

Title: Automatically disable inactive account
Post by Pete Finnigan on Sep 10^th, 2007, 4:08pm

Hi,

Assume a user does not use his account for 30 days, that is, he does not log in for this period. Is it possible to automatically disable/lockout his account after the 30-day period using some database feature / parameter ?

I know it is possible to effect account lockout using
sql eg. ALTER USER scott ACCOUNT LOCK. However, I am interested in automatically performing this activity.

Title: Re: Automatically disable inactive account
Post by Pete Finnigan on Sep 11^th, 2007, 11:43am

Hi,

You can use password management to acomplish this. Set a password expirey for 30 days and set no grace time. That way when the person comes to use their account again after 30 days it will be locked and expired.

hth

cheers

Pete