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