RE: User "vanishes" from pwd-file after "create controlfile command"

Whenever you recreate the controlfiles or open with resetlogs, you have to
grant sysdba to special users.  This means that you have to log on as oracle
and connect as sysdba to do this.  Otherwise some user could just recreate
the controlfiles and then have sysdba privs.

HTH,
Ruth

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Daiminger, Helmut
Sent: Tuesday, December 28, 2004 6:33 AM
To: LazyDBA.com Discussion; oracle-l@xxxxxxxxxxxxx
Subject: User "vanishes" from pwd-file after "create controlfile
command"


Hi!

I just encountered a strange phenomenon: on all our instances, we have a
user called "ADMRMAN" that is used for RMAN/Legato backups. This user
has sysdba privileges.

On a test instance I did a: alter database backup controlfile to trace
then I altered MAXDATAFILES and re-created the controlfile.

But then the user ADMRMAN was no longer able to connect as sysdba...

A "more" on the pwd-file showd that ADMRMAN was still in it, but some
characters in the pwd-file changed (probably "active" flag or something
like that).

Does re-creating the controlfile delete users from the pwd-file?

This is 9.2 on HP-UX 11i.

Thanks,
Helmut
--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Other related posts: