Replica set with both database password and user password

C

CK

Has anyone of you can clear the database password from replica set which
using user lever security? cause actual i have a program that access replica
set that protected by user level security, but strange things happen that it
suddenly protected by database password.
 
O

Olduke

Access is designed to use EITHER database password OR User/Group Security.
If you can, delete the database password and you should be OK.
When replicating or copying a database, always ensure that all of the
security features are disabled on the original. You should not be using the
security wizard or database password on your original. The original remains
your prototype and should be stored in a safe place. The copy is the one to
actually be used and this is what you place security or passwords on when it
is distributed to the users.
 
C

CK

from my knowledge, I think the access is not possible to unset the database
password, if the replica is protected from user/group security.

And anyone of you really try to set both database password and user/group
security at the replica?? I think none of you can right? if can please do let
me know. And also let me know how to clear the database password from
user/group security protected access replica database.

Thanks a lot.
 
O

Olduke

Try the following:
Open the database using "Open Exclusive". You will probably be asked for
the database password, then the user/group password.
Open the security window, go to database password and delete the database
password. Close the database. That should get rid of the database password.
Note: if the database security window is faded out, this means you don't
have permission to do this. Whoever your database administrator is will have
to do it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top