Read Only Access to Stored Procedures

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Colette - 28 Jul 2005 14:59 GMT

We do not allow anyone except DBA's the DBO access permission in our
organization for the "production" environment. The programmers get
DataReader/DataWriter access in production, however, they are wanting
read-only access to the stored procedures.

Does anyone know of a why to give them READ ONLY access to stored procedures?

Thanks for your help.

Colette

Reply to this Message

Mike Epprecht (SQL MVP) - 28 Jul 2005 15:58 GMT

The only permissions you can grant Users WRT SP's is Execute.

Either a user is allowed to execute a SP or not.

I would seriously re-consider Developer Access to production. Developers
should only be in development, and support staff read only production rights.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

> We do not allow anyone except DBA's the DBO access permission in our
> organization for the "production" environment. The programmers get
[quoted text clipped - 6 lines]
>
> Colette

Reply to this Message