RE: Did you ever have one of those days?
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 21 May 2004 09:28:39 -0500
Great idea! I scripted it like this:
declare
cursor c1 is
select username,password,account_status
from dba_users
where account_status =3D 'EXPIRED'
order by 1;
begin
for cu in c1 loop
dbms_output.put_line('alter user '||cu.username||' identified
by =
values '''||cu.password||''';');
end loop;
end;
I captured the output in TOAD, executed it, and all *seems* well. =
Thanks much! If this were in Trillian I'd include =
(b)(b)(b)(b)(b)(b)(b)(b)(b)(b)(b)(b)...
Rich
Rich Jesse System/Database Administrator
rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
> From: oracle-l-bounce@xxxxxxxxxxxxx
> Sent: Thursday, May 20, 2004 6:27 PM
> Subject: Re: Did you ever have one of those days?
>=20
>=20
> FYI... Figured I'd also send an example:
>=20
> SQL> create user tim identified by tim;
>=20
> User created.
>=20
> SQL> grant connect to tim;
>=20
> Grant succeeded.
>=20
> SQL> alter user tim password expire;
>=20
> User altered.
>=20
> SQL> select username, password, account_status from dba_users where=20
> username =3D 'TIM';
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
