Re: Did you ever have one of those days?

Guess what? The alter user trick works! At least it does on 8.1.7.4 and 9.2.0.3...

Good call Paul!

Rich... Paul just provided the solution to you problem!

I think you owe him a virtual beer!

Tim

Paul Drake wrote:

>--- "Jesse, Rich" <Rich.Jesse_at_quadtechworld.com>
>wrote:
>
>
>>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
>>
>>
>
>Rich,
>
>might I suggest the following:
>http://www.beeradvocate.com/beer/rate_results/207/645/
>
>would spooling out the current hashes and resetting
>ALTER USER <username> IDENTIFIED BY VALUES "<hash>";
> reset the expiration date?
>
>hth.
>
>Paul
>
>
>
>
>__________________________________
>Do you Yahoo!?
>Yahoo! Domains – Claim yours for only $14.70/year
>http://smallbusiness.promotions.yahoo.com/offer
>----------------------------------------------------------------
>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
>-----------------------------------------------------------------
>
>

-- 
Regards,
Tim Johnston
Tel: 978-322-4226
Fax: 978-322-4100



----------------------------------------------------------------
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
-----------------------------------------------------------------