How To: Disable My Page Creation for ALL Users & Delete All My Pages

In some instances, organizations do not want their users to be able to create My Pages due to the potential for system performance (if someone is housing media, videos, lots of pages, etc) or the possibility for inconsistent data/documents. 

In order to fully remove the ability for users to create My Pages, please see the steps below. Some items can be done from the front end and others require SQL server access. 

1. Remove the 'My Pages' link from the navigation tree.

Portal Tools > Manage Portal Framework > Navigation Settings > Select 'MyPagesLink' > Hide Link.  

2. Remove the 'My Settings' link from the navigation tree. 

Users could also get to their My Pages from under My Settings in the navigation tree so you can hide the 'My Settings' link from the navigation tree as well. Please note that this in addition will remove users' ability to access everything under My Settings, including My Workgroups, My Profile, and My Preferences. 

Portal Tools > Manage Portal Framework > Navigation Settings > Select 'MySettingsLink' > Hide Link. 

If you would like a way for them to be able to access “My Profile” so they can change/update there as needed you can make a link or button somewhere that goes to https://YOURPORTALNAMEHERE/UserTools/My_Profile.aspx 

3. Delete the policy preference for all users so My Pages can no longer be created. 

- Take a backup of the framework database. A sample looks like this- Production_Portal_PortalFx

- Run the select query to confirm how many records should be returned and then deleted. 

SELECT PermissionID, AppID, PermissionKey, ObjectID, UserID
FROM PWObjectPermissionByUser
WHERE (PermissionKey = 'CanCreateMyPages')

- Delete the policy preference

delete
FROM PWObjectPermissionByUser
WHERE (PermissionKey = 'CanCreateMyPages') 

4. Delete all My Pages so they are no longer accessible through links/bookmarks. 

- Take a backup of the framework database. A sample looks like this- Production_Portal_PortalFx

- Run the select query to confirm how many records should be returned and then deleted. The database name in bold may need to be updated to reflect your database name. 

SELECT *
FROM [Production_Portal_PortalFx].[dbo].[PWPages]
where viewID in (SELECT [ViewID]
FROM [Production_Portal_PortalFx].[dbo].[PWViews]
where viewtype = 1)

- Delete the My Pages

delete
FROM [Production_Portal_PortalFx].[dbo].[PWPages]
where viewID in (SELECT [ViewID]
FROM [Production_Portal_PortalFx].[dbo].[PWViews]
where viewtype = 1)