Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replication and Security

Status
Not open for further replies.

Nazgul79

MIS
May 30, 2001
12
AU
I have a secured db that is controlled by a mdw file and has about 5 usernames attached, each with a different level of access.

I have created a replica of the database that uses the same security and mdw.

I am having trouble when it comes to the actual syncing of the Master and Replica. I want to have one of the following things occur:
1) When the user closes out of the database, either the Master or Replica, the databases sync OR
2) Another database opens at a certain time, connects to the Master and Replica and syncs them.

I have code for 2) but it fails in the connection as the Master and Replica are secure db's.

So, if someone can suggest a way to do 1) or how to connect the db's as an authorised user I would be most grateful.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top