Grant view definition isn't working

Question

Grant view definition isn't working

Chitown

Hall of Fame

Points: 3239
More actions
September 6, 2016 at 8:42 am

#329657

All, I granted user to see all SPs in all DBs but he is not able to see any. Am I missing any steps?
This is what I ran: GRANT VIEW DEFINITION TO USER

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Michael L John One Orange Chip Points: 27055 More actions · Answer 1

Chitown (9/6/2016)
All, I granted user to see all SPs in all DBs but he is not able to see any. Am I missing any steps?
This is what I ran: GRANT VIEW DEFINITION TO USER

What did you grant view definition ON?

You seem to have left out the object or schema that you were granting the rights to.

Such as:

GRANT VIEW DEFINITION ON SCHEMA::dbo TO db_view_schema

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Chitown Hall of Fame Points: 3239 More actions · Answer 2

Michael L John (9/6/2016)
Chitown (9/6/2016)
All, I granted user to see all SPs in all DBs but he is not able to see any. Am I missing any steps?
This is what I ran: GRANT VIEW DEFINITION TO USER
What did you grant view definition ON?
You seem to have left out the object or schema that you were granting the rights to.
Such as:
GRANT VIEW DEFINITION ON SCHEMA::dbo TO db_view_schema

Still not working.

GRANT VIEW DEFINITION ON SCHEMA::administration TO

Sue_H SSC Guru Points: 90860 More actions · Answer 3

And did you check all of the users other permissions as well? If they have a deny view somewhere individually or through a role, deny takes precedence. If you did check, please provide the query that was used.

Sue

Chitown Hall of Fame Points: 3239 More actions · Answer 4

That query worked fine. That user was looking in the wrong server. Don't you just love that?:-)

Michael L John One Orange Chip Points: 27055 More actions · Answer 5

Nice!!!

I've never had that kind of stuff happen! :w00t:

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Sue_H SSC Guru Points: 90860 More actions · Answer 6

Kind of like all the scripts that accidentally get run in master...."I can't find the table I created in my database".

Thanks for posting back Chitown - really helps others who come across the thread.

Sue