Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> about find unused users in oracle database

about find unused users in oracle database

From: <esthershensh_at_yahoo.com>
Date: Tue, 31 Jul 2007 11:25:59 -0700
Message-ID: <1185906359.836692.68240@19g2000hsx.googlegroups.com>


HI,

I'm wondering is there any simple way to find unused oracle users for a period of time ? ( which has not logged into the oracle database for some period time ).

I found we could enable audit connect or create logon/logoff trigger to find those info.

But is there any simple way ( like record login info in oracle database somewhere )

Thanks very much for any suggestion on it. Received on Tue Jul 31 2007 - 13:25:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US