Re: Developers and prod servers

From: Paul (Paul.no.spam.please.Schlieper@communication.gc.ca)
Date: 03/12/03 

From: "Paul" <Paul.no.spam.please.Schlieper@communication.gc.ca>
Date: Wed, 12 Mar 2003 09:04:12 -0800

Hi Dan,

Thanks for the reply, that's what I wanted to know.

Paul

>-----Original Message-----
>You can add them to the db_datareader role in the desired
databases.
>They will not be able to create database objects as long
as you haven't
>granted them CREATE permissions or added them to the sysadmin,
>db_ddladmin or db_owner roles. Note that members of the local
>administrators group are sysadmin role members by default.
>
>--
>Hope this helps.
>
>Dan Guzman
>SQL Server MVP
>
>-----------------------
>SQL FAQ links (courtesy Neil Pike):
>
>http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
>http://www.sqlserverfaq.com
>http://www.mssqlserver.com/faq
>-----------------------
>
>"Paul" <paul.no.spam.please.Schlieper@communication.gc.ca>
wrote in
>message news:07dc01c2e8ac$a051ce90$a501280a@phx.gbl...
>> Hi,
>>
>> Using SQL2K on Win2K.
>>
>> How do I go about granting my developers read-access to the
>> production servers, but prevent them from changing stored
>> proc code on said servers? I only want them to be able to
>> create sprocs on dev boxes.
>>
>> TIA,
>>
>> Paul
>>
>>
>
>
>.
>

Relevant Pages

  • Re: db_owner
    ... Thanks Dan, much appreciated. ... There is only one guest user in the system databases, ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Problem updating a table
    ... Yes in both servers the 2 databases have the same name, ... > Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL active - active cluster hardware design?
    ... if you can find TPC-C benchmarks to be better on Itanium, ... For x64 vs IA-64, as I said it depends a lot on how the system vendors make ... x64 servers may be sufficient. ... You will need to know number of users and databases. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL active - active cluster hardware design?
    ... if you can find TPC-C benchmarks to be better on Itanium, ... For x64 vs IA-64, as I said it depends a lot on how the system vendors make ... x64 servers may be sufficient. ... You will need to know number of users and databases. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SAN (NetApp SnapMirror) replicated Exchange databases usability
    ... to stage Exchange 2007 servers at siteB with SG's and databases that are ... This is achieved by having Exchange ...
    (microsoft.public.exchange.design)
Quantcast