Administrators group locked out

K

Kurt Petteloot

Can anyone help us with following problem?
The project managers security template has been applied onto the
Administrators group. Obviously this template has only limited set of
permissions and as a result all users that are member of the administrators
group have no access anymore to the admin functionlaity. This leaves us in a
situation where we can no longer maintain the users etc...
Is there any way that we can solve this situation?

Any help is highly appreciated since this is more than just annoying.

Kind regards
Kurt
 
G

Gary L. Chefetz [MVP]

Kurt:

If you do not have a backup recovery method, you can fix this in the
database. What you need to do is open the following tables in the Published
database:

MSP_WEB_SECURITY_GROUPS
MSP_WEB_SECURITY_GROUP_MEMBERS
MSP_RESOURCES

You need to populate the MSP_WEB_SECURITY_GROUP_MEMBERS table with one row
for one user who then can add everyone back to the Administrators group. The
fields you are concerned with populating are WRES_GUID which corresponds to
RES_SECURITY_GUID in the MSP_RESOURCES table and WSEC_GRP_GUID which
corresponds to the field of the same name in MSP_WEB_SECURITY_GROUPS.

Note that I have not had this problem and I haven't tested this fix, however
I suggested this to a friend with nearly the same problem the other day, and
he reported to me that it worked.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
 

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

Project Workspace: Permission Level erased from Customed group atworkspace creation 2
Users missing from Advanced Permissions after TM Group Update 1
Project Server 2007 - strange things happening to groups / permissions 0
Accessing historical PWA/Sharepoint documentation 2
WSS: Local admin accnt in local admin group. 2
Should you set categories from a template? 2
Removed the EPM Administrator from the Administrator's Group in Project Server 2007 0
Credentials Prompt 9

Top