- "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
-----------------------------------------------------------------
Received on Thu May 20 2004 - 16:22:25 CDT