Announcements
Is there another method, other than running Synchronize All Ownership & Security update scenario, to enable a new view to be displayed in the QQ.VIE.00 list of SQL Views? Thanks in advance.
*This post is locked for comments
We have added the following to the bottom of our scripts used to Create Views:
GRANT SELECT ON [dbo].[VIEWNAME] TO [07718158D19D4f5f9D23B55DBF5DF1] AS [dbo]
GO
GRANT SELECT ON [dbo].[VIEWNAME] TO [E8F575915A2E4897A517779C0DD7CE] AS [dbo]
GO
GRANT CONTROL ON [dbo].[VIEWNAME] TO [MSDSL] AS [dbo]
GO
If I remember well there was a script or a stored procedure for this. Take a look at the GrantViewPermissions sp
#1
Community Member
136
#2
Mohamed Amine Mahmoudi
102
Super User 2025 Season 1
#3
REUser
8
Share
Report
All responses (
Answers (
