How do you unsecure a secured database?

C

Charles

I secured my database with the Security Wizard and all is working well.
Problem is, now I can't import into other databases because this one is
secured. I would like to undo what I did with the security wizard and get
my database back to an unsecured state. Any help would be greatly
appreciated. Thank you
 
C

Charles

34. How can I "de-secure" a database?
You must have Administer permissions and/or be a member of the Admins group
in the workgroup information file that helped protect the database. Grant
full permissions to the Users group and the Admin user account. Put the
Admin user back in the Admins group and remove the password from the Admin
user. You will not be prompted for a logon ID and password once the password
is removed from the Admin user. Optionally, you can also run the Security
Wizard again to transfer ownership of all objects back to the Admin user,
but the wizard will also remove permissions from the Users group, which you
may not want.
 

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