RE: Read Only Access to Stored Procedures
From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 07/28/05
- Next message: Ian: "Permissions to public in the master database"
- Previous message: Colette: "Read Only Access to Stored Procedures"
- In reply to: Colette: "Read Only Access to Stored Procedures"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 28 Jul 2005 07:58:06 -0700
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/
"Colette" wrote:
> 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
- Next message: Ian: "Permissions to public in the master database"
- Previous message: Colette: "Read Only Access to Stored Procedures"
- In reply to: Colette: "Read Only Access to Stored Procedures"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
