Re: security in development environnement
From: BP Margolin (bpmargo@attglobal.net)
Date: 02/16/03
- Previous message: zens: "Pls. Ignore - Wrong group - Replication snapshot failure"
- In reply to: Sylvain: "security in development environnement"
- Next in thread: BP Margolin: "Re: security in development environnement"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "BP Margolin" <bpmargo@attglobal.net> Date: Sun, 16 Feb 2003 13:48:58 -0500
Sylvain,
Assuming you have all the developers in a database role named "developers":
grant create procedure to developers
Check out the "GRANT" command in the SQL Server Books Online for additional
information.
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"Sylvain" <junesyl@statcan.ca> wrote in message
news:01c801c2d565$8e4c3f50$a401280a@phx.gbl...
> I am a new DBA and wondering how can I keep the control of
> the database objects like tables in a developpement
> environnement using the SQLSEVER security.
>
> I have created the database and tables. Developpers need
> to create procedure in the database and full access to the
> data.
>
> I do not want to give them the database role db_owner
> because they can modify all database objects including
> tables.
>
> I have given the database roles db_datareader and
> db_datawriter to the developper and the permission of
> procedure creation on the database.
>
> Developpers are able to manage all data but not able to
> create procedure associate with the owner DBO.
>
> Is there a way to give permission other than db_owner ?
>
> IF there is no other option that given db_owner
> permission, how can I control objects to make sure no bad
> modification will be done on the tables.
>
> thanks all
>
>
- Next message: BP Margolin: "Re: security in development environnement"
- Previous message: zens: "Pls. Ignore - Wrong group - Replication snapshot failure"
- In reply to: Sylvain: "security in development environnement"
- Next in thread: BP Margolin: "Re: security in development environnement"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
