February 19, 2009 at 1:57 pm
I have a windows group " DEvelopers" which has access to view definition at server level granted by "sa" role. That group can view the definition of a view in database A but not on Database B, how is that? what do i need to check?
February 19, 2009 at 2:33 pm
Do they have rights to enter the database?
K. Brian Kelley
@kbriankelley
February 20, 2009 at 6:59 am
yes they do.
When i explicitly give view definition access on the database it working but i was under assumption that if i give the same access on the server they can view difinition of all the database on that server BUT it is not doing so? isnt it weired???
February 22, 2009 at 3:27 pm
Did you grant VIEW DEFINITION on a particular database per chance? If you granted VIEW ANY DEFINITION, as long as they have the ability to access the database, they should be able to enter and view the T-SQL for a particular object which is applicable, such as a stored procedure or view.
K. Brian Kelley
@kbriankelley
February 26, 2009 at 8:53 am
But my doubt is , what is the difference between " VIEW DEFINITION" on server and database. I was expecting that if i grant view definition on the server level, the user has to see definition of a view/table from any database he has access to but its not doing so, i am giving this permission on each database explicitly.
thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply