Lost admin rights for my multiuser database.



I created a multiuser database on a network drive and somehow I lost my admin
rights. Everything was working fine and i can still log in with my user id
and the admin id which are both in the administrator group with all rights.
However when i try to modify the database it says that I must have
administrator rights. I am also still able to reasign users to different
groups, but I can't change ownership of objects or modify them.



Rick B

"and the admin id which are both in the administrator group"

You do realize that if the "admin" id has full rights, anyone can take this
file and open it with the default system.mdw and they will have admin

One of the most important steps in the security process is to remove "admin"
user id rights.


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

Similar Threads