Re: Did you ever have one of those days?

  • From: Paul Drake <discgolfdba@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 20 May 2004 14:25:19 -0700 (PDT)

--- "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
> Like when you're moving a table that contains a list
> of all valid OS =
> user accounts in order to maintain (disable) Oracle
> accounts, only you =
> fat fingered the SQLLoader module causing all
> employees to have their =
> respective DB accounts locked and expired?  Not only
> that, but that the =
> program you've written to do this from the OS
> explicitly sets the SID to =
> production because otherwise it won't know what SID
> to connect to when =
> this job is normally run via cron?  And I've
> suddenly remembered that =
> while there's an "UNLOCK" clause for ALTER USER,
> there's no UNEXPIRE.
> <heavy sigh>  The Response Center's gonna love me...
>  At least I had =
> enough sense to use groups to segregate user's
> read-only Oracle accounts =
> from the management and app accounts.
> Yes, it is Beer Day.
> Rich


might I suggest the following:

would spooling out the current hashes and resetting 
 reset the expiration date?



Do you Yahoo!?
Yahoo! Domains ? Claim yours for only $14.70/year 
Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: