OraFAQ Forum: SQL & PL/SQL » Alter SYS & SYSTEM user on any database

Home » SQL & PL/SQL » SQL & PL/SQL » Alter SYS & SYSTEM user on any database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Alter SYS & SYSTEM user on any database [message #40001]

Tue, 03 September 2002 05:54

Paul
Messages: 164
Registered: April 1999

Senior Member

I have 96 instances and have to establish a policy of enforced SYS & SYSTEM password changes on a monthly basis.

I would like to schedule an OEM job to do it; does anyone have any experience of doing this? I believe it can be done as a PL/SQL job using the DBMS_SQL.OPEN_CURSOR and DBMS_SQL.PARSE procedures to execute the alter user command.

Any help gratefully received.

Report message to a moderator

Re: Alter SYS & SYSTEM user on any database [message #40002 is a reply to message #40001]

Tue, 03 September 2002 06:27

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

yup.
you can use dynamic sql for this.
with 8i above it relatively simple (no need to use DBMS_SQL.OPEN_CURSOR and DBMS_SQL.PARSE procedures)
something like
[code]create or replace procedure test
as
begin
execute immediate ' alter user sys .... ';
end;

and schedule this job to be run, at specified intervals
using DBMS_JOB

Report message to a moderator

Previous Topic:	Help With 5 Questions
Next Topic:	Procedure to create a new user and list the new user in a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 15:08:04 CDT 2024