DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Standby database question.

Hybrid View

  1. #1

    Standby database question.

    Just a quickie..

    if we grant sysoper to a user in the primary database, will the grant go through to the standby database and appear in the passwordfile on the standby server? Tried it and it doesnt seem to work. Cant do the grant manually on the standby db without activating the db...

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Yes the right way of doing it is manually...

    regards
    Hrishy

  3. #3
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    It seems be impossible to do GRANT work because the database is opened READ ONLY. It might be a solution to copy the password file to Standby server. Anyone try it?
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width