How do you unsecure a secured database?

  • Thread starter Thread starter Charles
  • Start date Start date
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
 
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.
 
Back
Top