Project Server Experts Community Site

You May Have Been Automatically Redirected to This Page, Which Has a New Address (URL). Please Update Your Bookmarks / Favorites Accordingly.

Resolution

After you have created a custom menu in Project Web Access, you can add security to control which Groups and/or Users can see the custom menu. Complete the following steps to use the User Defined 1 permission to control access to your custom menu:

1. Open the table MSP_WEB_SECURITY_MENUS in SQL Server Enterprise Manager.

2. Find the appropriate record(s) for the custom sub-menu item(s). You can use the WSEC_CUSTOM_MENU_NAME field as a guide. Sub-menu items have a value of zero in the WSEC_MENU_IS_TOP_LEVEL.

3. Write down the value(s) of the WSEC_MENU_ID field.

4. Close the table.

5. Open the table MSP_WEB_SECURITY_PAGES in SQL Server Enterprise Manager.

6. Find the record(s) where the WSEC_PAGE_MENU_ID equals the value(s) found in step 3.

7. Change the WSEC_PAGE_ACT_ID to 150 (151 if using User Defined 2, 152 if User Defined 3) of each record found in step 6.

8. Close the table.

9. Modify the appropriate security groups to allow/deny access to the custom menu item by changing the permissions for User Defined 1.

10. You must log out of Project Web Access for the changes to take effect!