eOne Smartview - Smartview tables - security access to smartview favorites, lock or unlock favorites

Sometimes, if you accidentally remove access to SA for a smartview, you can never get back in to see it again.

You can manually update the security tables to give access again

You can also use the SV00108 table to force-lock favorites to prevent anyone from making changes.

• dynamics.dbo.sv00100 - Favorites index
• dynamics.dbo.sv00101 - Favorites layout
• dynamics.dbo.sv00102 - Favorites restrictions
• dynamics.dbo.sv00103 - Favorites grouping
• dynamics.dbo.sv00104 - Favorites to Company link
• dynamics.dbo.sv00105 - Favorites security roles (insert security records here to grant access)
• dynamics.dbo.sv00108 - Favorite Lock (Put your favorite id here to lock it from changes, remove it to allow changes)
• dynamics.dbo.sv00110 - Favorites status
•