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: inactive users how find

Re: inactive users how find

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Mon, 25 Jun 2007 12:12:04 GMT
Message-ID: <pan.2007.06.25.12.12.05@verizon.net>


On Wed, 13 Jun 2007 20:17:20 +0200, krzys 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?

The proper methodology is known as "kill them all and let God sort them out".
You do "alter user <username> account lock;" for any account that you suspect of being dead and, if nobody screams, drop the account in a month.

-- 
http://www.mladen-gogala.com
Received on Mon Jun 25 2007 - 07:12:04 CDT

Original text of this message

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