Re: grant sysdba to user on hot standby

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_at_freelists.org [mailto:oracle-l-
> bounce_at_freelists.org]
> 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.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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