How do I undo and remove wrong security settings

Question

My database is ready for some end user testing, and I setup some workgroup permissions. Now I as the designer can not make changes to it. How do I undo and or remove the permissions? Is there a way at all? Any help would be appreciated.

Answer 1

Oh, and if you didn't save a copy before applying ULS - I've been there many, many years ago.  I've never forgotten since because I had to create the entire database again from scratch and that was a lot of work.

Answer 2

The only way would be if you had saved a copy which wasn't User Level Security enabled or if you can log in as part of the Admin group and then go through all of the objects and make sure that they are all set to full permissions for the admin so you can then add the Admin user (user name Admin) back into the Admins (note the S) Group.

If you can't do either of those, then you basically are in a very bad spot.

Answer 3

Do I log in as the administrator of the computer or of the database? If it is the database how do I log in as the administrator? Note I did not set a password for the database.

Answer 4

Luckily I will not have to create it again from scratch. I imported the tables and data to another database file. The queries came with them, but I will have to recreate the forms that I made.