Home » Server Options » Data Guard » Replication of users/passwords by Data Guard? (Oracle Database 10.2 EE)
Replication of users/passwords by Data Guard? [message #281064] Thu, 15 November 2007 10:30 Go to next message
Messages: 1
Registered: November 2007
Location: Frankfurt, Germany
Junior Member

As we are cosidering using Data Guard, one small question regarding user management:

When new users are created on production, or when existing users change their passwords, will Data Guard transfer those changes to the Physical/Logical Standby Database just like any "normal" DML?

Or is there anything special to be taken care of so all users will be able to log in after a failover-switch to Standby?

Thanks in advance!
Re: Replication of users/passwords by Data Guard? [message #281066 is a reply to message #281064] Thu, 15 November 2007 10:42 Go to previous message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Physical and logical standby are 2 different things.
With physical standby all is replicated, there is no difference with the primary.
With logical standby dictionary changes (among others) are not replicated.

Previous Topic: Fail over to Secondary
Next Topic: Dataguard automatic failover question
Goto Forum:

Current Time: Sat Oct 22 19:00:42 CDT 2016

Total time taken to generate the page: 0.04336 seconds