Beginning in Brazos Portal v1.13 a customization option was added to Brazos Portal that disables the creation of personal views, or "My View", for all portal users. In builds where this option is enabled, users will only have access to views that are shared with them directly or via a group. If you would like this customization added to your version of Brazos Portal, please open a support ticket at http://support.bp-3.com.
This customization will only affect new Brazos Portal users. Users that already have a personal view created will retain their personal view. This article includes a SQL statement below that will allow you to remove personal views for all users.
If you don't already have "My View" disabled in your custom Brazos Portal build, stop here, the rest of this article does not apply to you. If you want "My View" disabled in your build please open a support ticket requesting that customization.
How to create personal views when personal views are disabled
When personal views are disabled, View Admins can create one-off "personal views" for users by creating a new view, sharing it with an individual user, and giving them edit rights to the view.
Remove personal views for all users
If you wish to remove all existing personal views follow these steps:
WARNING: The following SQL will delete all personal views, also called "My View" from your database. This should only be done if you have the customization option to prevent creation of personal views enabled and you are wanting to remove all personal views from your environment.
- Backup your Brazos Portal database.
- Run the following SQL against your Brazos Portal schema.
Note this SQL assumes your Bazos Portal schema is named brazos_portal. If your schema has a different name you will need to replace all occurances of brazos_portal with your schema name:
DELETE FROM brazos_portal.groupview WHERE (name = 'My View' OR name like '%''s View') AND view_id IN (SELECT view_id FROM brazos_portal.shared_view GROUP BY view_id HAVING COUNT(view_id) = 1) AND view_id NOT IN (SELECT view_id FROM brazos_portal.shared_view WHERE type = 'group');