I knew it was stored in the password file, but for it to show up in v
$pwfile_users I assumed the grant statement had to update an
underlying table.
I didn't spend much time with it, but was surprised I could issue the
command on a read only database.
thanks, Steve
On Jul 8, 2006, at 12:16 AM, Tanel Poder wrote:
As sysdba and sysoper privileges have to be kept outside the database (how
could you log on before starting database up if the password info is inside
the shut down database?) - these accounts are stored in passwordfile as
well.
So copy primary's passwordfile over to standby too after creating the user &
granting the priv and see if it works.
Tanel.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l- bounce@xxxxxxxxxxxxx]
On Behalf Of Steve Perry
Sent: 08 July 2006 11:35
To: oracle-l
Subject: grant sysdba to user on hot standby
I didn't know you could do this and thought I'd share. It may be well known and in the manuals, but I didn't see it.
I needed to setup an RMAN backup for somebody with a 10g Data guard implementation. They wanted me to backup the standby and not the primary.
-- //www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l