dec4141
asked on
Stored Procedures
I have three developers and due to regulatory requirements I need to keep all stored procedures on our live system as read only. They have full ownership in the development and pilot environments.
Is there a simple way to allow the developers read only access for stored procedures in the production database?
I gave them execute this allows them to run the sp but not open and view it.
We are on MS SQL 2005.
Thanks
Don
Is there a simple way to allow the developers read only access for stored procedures in the production database?
I gave them execute this allows them to run the sp but not open and view it.
We are on MS SQL 2005.
Thanks
Don
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.