RE: Did you ever have one of those days?

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Fri, 21 May 2004 08:42:36 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA650146C2BF@25exch1.vicorpower.vicr.com>

I'll take a couple of cases!! Been one of those weeks!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Paul Drake [mailto:discgolfdba_at_yahoo.com] Sent: Thursday, May 20, 2004 5:25 PM
To: oracle-l_at_freelists.org
Subject: Re: Did you ever have one of those days?

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

Rich,

might I suggest the following:
http://www.beeradvocate.com/beer/rate_results/207/645/

would spooling out the current hashes and resetting=20 ALTER USER <username> IDENTIFIED BY VALUES "<hash>";  reset the expiration date?

hth.

Paul

=09

        =09

---

Do you Yahoo!?
Yahoo! Domains - Claim yours for only $14.70/year http://smallbusiness.promotions.yahoo.com/offer=20

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri May 21 2004 - 07:39:39 CDT