Link to home
Start Free TrialLog in
Avatar of AaronRosema
AaronRosemaFlag for United States of America

asked on

SQL 2005 Read Only Database Object Permissions

I am looking for a way to allow my developers to be able to read table, stored procedure, view and function permissions without them being able to change them.  

I am thinking that I need to give them access to some of the system views, but I do not know which ones are needed for this.  db_securityadmin allows them to change permissions which they should not be able to do.
Avatar of Chris Mangus
Chris Mangus
Flag of United States of America image

I don't know the exact system tables you need off the top of my head, but, I would create a custom view into the appropriate system table and grant your developers SELECT permission on the view you create.
Avatar of AaronRosema

ASKER

There is no way to do this without also being able to grant permissions.
Disagree with poster.  It can be done and *is* done in many organizations.
Then do you know how to do it?  If not, I will just delete the question since I am not getting a solution.
I gave you enough info to be able to figure it out.  If you're unable to figure it out then I will create a view and send you the code.  You will need to be able to give SELECT permission to your developer group to the view.
ASKER CERTIFIED SOLUTION
Avatar of Chris Mangus
Chris Mangus
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial