Oracle-L: RE: Unused users for the last 30 and 60 days.

From: Freeman, Robert <Robert_Freeman_at_csx.com>
Date: Thu, 28 Feb 2002 12:18:02 -0800
Message-ID: <F001.0041BB64.20020228121802@fatcity.com>

You could audit connects and use that to determine which accounts have not connected to the database in the last 30-60 days. Connect auditing will have 0 performance impacts, but you will need to manage the audit table and write a good SQL script to give you the info you need.

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him.

-----Original Message-----
Sent: Thursday, February 28, 2002 1:54 PM To: Multiple recipients of list ORACLE-L

Hi All,

I want to have report of all the users who has not used their Oracle username for the last 30 and 60 days.
Any views how can I get the report.

Thanks,
Deepender

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Deepender.Gupta_at_newpower.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Freeman, Robert
INET: Robert_Freeman_at_csx.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------