Re: Dormant database user accounts

  • From: "Mladen Gogala" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "mgogala@xxxxxxxxx" for DMARC)
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 13 Mar 2015 18:06:42 -0400

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

--
//www.freelists.org/webpage/oracle-l


Other related posts: