Comments
Sort by recent activity
Hi,
This issue comes with column level permissions on a view. Code below
In the database it is: GRANT SELECT ([ColumnName]) ON [dbo].[vwViewName] TO [Role]
When you select the commit changes window you see this GRANT SELECT ON [dbo].[vwViewName] TO [Role]
It seems to be ignoring the column permissions and granting select on the whole object.
Apologies for replying through the forum, I couldn't workout how to get to the support ticket
[/img] / comments
Hi,
This issue comes with column level permissions on a view. Code below
In the database it is:GRANT SELECT ([ColumnName]) ON [dbo].[vwViewName] TO [Role]
...
Hi,
Thanks for your response. I have had another look at this and it still doesn't appear to be doing what im after.
What I was looking for was to be able to add a user and all table, views, functions and SP and be able to see what objects that user has permissions to.
Barry / comments
Hi,
Thanks for your response. I have had another look at this and it still doesn't appear to be doing what im after.
What I was looking for was to be able to add a user and all table, views, funct...