OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » dba users

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dba users [message #21633]

Mon, 19 August 2002 19:31

dennis
Messages: 31
Registered: June 1998

Member

hi to all!!

this is my first time to post a question here... i saw a lot of responses to a lot of difficult inquiries.. so might as well ask you this...

this is the requirement... a user will be automatically locked/disabled when it is not active for the past 90 days...

do you have any approach other than setting it to the profile?

i already have a password_lifetime in the profile set to 35 days...

i hope you guys can help me out...

thanks in advance...

Report message to a moderator

Re: dba users [message #21637 is a reply to message #21633]

Tue, 20 August 2002 04:58

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1. create a after logon trigger ( on that user) 
   to update a counter and also capture the timestamp.
2. Reset the counter if the difference in the
   timestamp is more than a day.
3. if the diference is more than 90 days,
   He, is the man u want.!
   Lock his account using 
   Alter user username command.

Report message to a moderator

Previous Topic:	reading huge text file by utl_file
Next Topic:	Using MAX() on a VARCHAR2 Column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 20:19:50 CDT 2024