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

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Tue, 28 Dec 2004 13:57:56 -0500
Message-ID: <004801c4ed0f$242e6850$8459000a@vttaxnet.tax.state.vt.us>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Daiminger, Helmut Sent: Tuesday, December 28, 2004 6:33 AM To: LazyDBA.com Discussion; oracle-l_at_freelists.org 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 Received on Tue Dec 28 2004 - 12:57:09 CST