L
Lester.Lovelock
Hi,
I know that this is question that has been asked before and has never
been successfully replied to (as far as I can see through searching)
so I thought I'd add a fix that we have developed.
The issue appears to stem from removing groups from the 'My
Organization' category, which seems to remove the link between the
built-in Administrator account and the 'My Organization' category.
Unfortunately there is no direct asscoiation with the Administrator
account and the My Organization category that we could find through
SQL. This workaround adds the administrator account to the
administrators group, which in turn is associated with the category,
so appears to be an acceptable workaround.
In order to get the built in administrator account to function again
you need to add it directly to the group through SQL. To do this:
1. Query (and return all rows for) the MSP_WEB_RESOURCES table and
copy and paste the WRES_GUID for the administrator account into
notepad.
2.Query (and return all rows for) the MSP_WEB_SECURITY_GROUPS table
and copy and paste the WSEC_GRP_ID for the Administrators group into
notepad.
3. Query the MSP_WEB_SECURITY_GROUP_MEMBERS table and insert the
values for the WSEC_GRP_ID and WRES_GUID that you noted before. Commit
the changes.
When you next login to PWA and 'Manage Users and Groups' you will
notice that the Administrator account is now available in the
Administrators group. DO NOT REMOVE IT or you will have to carry out
the previous steps again.
Hope this helps out someone.
Regards,
Lester Lovelock
Corporate Project Solutions Ltd
(http://www.cps.co.uk)
Supporting Enterprise Project Management
I know that this is question that has been asked before and has never
been successfully replied to (as far as I can see through searching)
so I thought I'd add a fix that we have developed.
The issue appears to stem from removing groups from the 'My
Organization' category, which seems to remove the link between the
built-in Administrator account and the 'My Organization' category.
Unfortunately there is no direct asscoiation with the Administrator
account and the My Organization category that we could find through
SQL. This workaround adds the administrator account to the
administrators group, which in turn is associated with the category,
so appears to be an acceptable workaround.
In order to get the built in administrator account to function again
you need to add it directly to the group through SQL. To do this:
1. Query (and return all rows for) the MSP_WEB_RESOURCES table and
copy and paste the WRES_GUID for the administrator account into
notepad.
2.Query (and return all rows for) the MSP_WEB_SECURITY_GROUPS table
and copy and paste the WSEC_GRP_ID for the Administrators group into
notepad.
3. Query the MSP_WEB_SECURITY_GROUP_MEMBERS table and insert the
values for the WSEC_GRP_ID and WRES_GUID that you noted before. Commit
the changes.
When you next login to PWA and 'Manage Users and Groups' you will
notice that the Administrator account is now available in the
Administrators group. DO NOT REMOVE IT or you will have to carry out
the previous steps again.
Hope this helps out someone.
Regards,
Lester Lovelock
Corporate Project Solutions Ltd
(http://www.cps.co.uk)
Supporting Enterprise Project Management