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.
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-lReceived on Fri Mar 13 2015 - 23:06:42 CET