November 30, 2012 at 3:46 am
Hi all
I have granted a user the VIEW DEFINITION permission using the following command:
USE DB
GO
GRANT VIEW Definition TO xxx\xxx
However he still can not see any views. If I look at the securables for his account I can not see anything granted, but as I did this at the database scope that is to be expected right?
Any ideas why he can't see the views?
Thanks
November 30, 2012 at 3:55 am
When you say he can't see any views, where is he looking? Are you sure that views actually exist in the database? Can he see tables, functions, stored procedures etc? What does he get if he runs:
SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'VIEW'
What do you get if you run it?
Don't forget that VIEW DEFINITON only grants him access to see the metadata - it doesn't allow him to SELECT any data from the view.
John
November 30, 2012 at 4:58 am
He is looking in SSMS, I ran the code and can see a list of views, I also got him to run it and he gets a list back.
Running sp_helptext he can also see the view definition. It looks like a SSMS issue, any ideas why he can't see the views in SSMS?
November 30, 2012 at 5:03 am
Not sure. One way you can investigate is by running a Profiler trace when you click on Views in SSMS to see what SQL Server does in the background. Get your use to run the code and see whether he sees the views like that.
John
November 30, 2012 at 5:22 am
Ok I think we have go to the bottom of it.
When he was expanding the Views section it was saying something like "Please view Object Explorer Details" in a blue icon.
Which when I did we can then see a list of the views (without schemas which is annoying). I think that the list of views was too large for his version of SSMS to handle and so was telling us to view it another way.
Thanks for the help
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply