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 -> Re: about find unused users in oracle database

Re: about find unused users in oracle database

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 31 Jul 2007 20:46:24 +0200
Message-ID: <46af8381$0$9303$426a74cc@news.free.fr>

<esthershensh_at_yahoo.com> a écrit dans le message de news: 1185906359.836692.68240_at_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.
|

"audit session"

Regards
Michel Cadot Received on Tue Jul 31 2007 - 13:46:24 CDT

Original text of this message

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