security in development environnement

From: Sylvain (junesyl@statcan.ca)
Date: 02/16/03

  • Next message: John Bell: "Re: security in development environnement" 
    From: "Sylvain" <junesyl@statcan.ca>
Date: Sat, 15 Feb 2003 18:46:07 -0800

    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

    Relevant Pages

    • Re: security in development environnement
      ... I would suggest that you use a version control system to hold the SQL to ... Therefore you can track changes and who does them. ... > the database objects like tables in a developpement ... > Developpers are able to manage all data but not able to ...
      (microsoft.public.sqlserver.security)
    • Re: security in development environnement
      ... developers will NOT be able to create stored procedure owned by "dbo". ... > I have created the database and tables. ... > Developpers are able to manage all data but not able to ... > Is there a way to give permission other than db_owner? ...
      (microsoft.public.sqlserver.security)
    • Re: Global datasets
      ... Sticking with the first method again. ... Populate my DataSet from the Database ... Create another control object instance ... re-instantiating it. ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: instant Lisp web application publishing
      ... flow of control (e,g. first log in the user, then show page x, than ... of Lisp if they want) ... flexible database that can be easily mapped into OOP terminology (so you ... Also I don't have a good candidate server to deploy it too. ...
      (comp.lang.lisp)
    • RE: 438 - Object doesnt support this property or method
      ... I created a new database and imported everything from the original. ... Missing is the Reference to the EzFTP control. ... Set con = Application.CurrentProject.Connection ...
      (microsoft.public.access.formscoding)