Logging related question [message #53111] |
Wed, 28 August 2002 08:19 |
Umashankar
Messages: 2 Registered: August 2002
|
Junior Member |
|
|
Is there a script that I can run to show the most recent activity for all my users on the Oracle database? For example, I'd like to retrieve a list of users that have NOT logged in within the past 90
days.
Uma
|
|
|
|
Re: Logging related question [message #53119 is a reply to message #53111] |
Wed, 28 August 2002 11:02 |
Trifon Anguelov
Messages: 514 Registered: June 2002
|
Senior Member |
|
|
"Oracle database" have many versions and the answer to your question depends on this information.
Speaking for Oracle 9i, you can create AFTER LOGON trigger and store username, sysdate, machine information. Then do select username from dba_users minus select username from this_table where logindate between sysdate and start_date;
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|