OraFAQ Forum: Server Administration » Lock or Delete Un-used IDs

Home » RDBMS Server » Server Administration » Lock or Delete Un-used IDs

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

Lock or Delete Un-used IDs [message #61286]

Mon, 12 April 2004 04:33

Jeffrey Mangan
Messages: 1
Registered: April 2004

Junior Member

Can I use Oracle to automatically expire logon IDs that have been idle (meaning have not logged-on for X-amount of days) ? If a supervisor does not inform us that an employee has left the company it would be nice to have Oracle auto-clean these user IDs after they have not logged-on in 7 days or so.

Report message to a moderator

Re: Lock or Delete Un-used IDs [message #61322 is a reply to message #61286]

Wed, 14 April 2004 07:13

Thiru
Messages: 1089
Registered: May 2002

Senior Member

you can setup database auditing (audit session) and setup a job that can lock users whose sysdate-timestamp > (threshold_number_of_days)

-Thiru

Report message to a moderator

Previous Topic:	LSNRCTL
Next Topic:	Change of character set in Oracle 8

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 08 13:43:59 CST 2025