September 6, 2011 at 12:57 pm
I have a developer want to view all stored procedures in a database.
I assign her the data reader role in the database, will he see the stored procedure?
If not, what permission can I assign her?
Thanks
September 6, 2011 at 1:03 pm
you'll want to give VIEW DEFINITION to them;
--at the database / schema level
Grant View Definition ON SCHEMA::[dbo] To [AlmostOwners]
--at the database level
Grant View Definition To [AlmostOwners]
--at the Login level in the master database
Grant View ANY Definition To [mydomain\SQLfriends]
that lets them see the definitions of all procs, views, functions, etc.
if you weant to do just procs and not views, for example, you have to grant at the per-object level for each of the objects in question instead.
GRANT VIEW DEFINITION ON MyProc TO SomeUser
Lowell
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy