Re: inactive users how find

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Wed, 13 Jun 2007 19:21:47 -0000
Message-ID: <1181762507.045118.151290@j4g2000prf.googlegroups.com>

On Jun 13, 10:17 pm, "krzys" <krzy..._at_buziaczek.pl> wrote:
> i have a question
> how can i find inactive users in oracle 81741.
> i have many account with "death" login and i need to remove this accounts
> how do it?

If you mean Oracle users that didn't login for a long time and should be dropped, then you could implement password expiration policy and then lock or drop all accounts that will expire after the specified password life time is over (note that such policy will eventually force active users to change their passwords, which may be undesirable.) See CREATE PROFILE documentation on how to create password policies and ALTER USER on how to assign profiles.

Alternatively you can create an AFTER LOGON database trigger and log all logins for some time, then drop or lock all accounts that didn't login at least once during monitored period.

Hth,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Wed Jun 13 2007 - 14:21:47 CDT