Re: Dormant database user accounts

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Fri, 13 Mar 2015 18:06:42 -0400
Message-ID: <55035F72.5080408_at_yahoo.com>



On 03/13/2015 05:09 PM, Hans Forbrich wrote:
> Mostly concur. For me, first step is to revoke CREATE SESSION
I find "ALTER USER <hapless user> ACCOUNT LOCK;" more aesthetically pleasing. Plus, I don't have to re-grant anything if I need to re-enable account.
-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 13 2015 - 23:06:42 CET

Original text of this message