Post reply

Developer Privileges

  • April 15, 2009 at 8:16 pm

    #208507

    Hello

    I am relatively new to SQLServer. In Oracle i used to grant the following privileges for a Developer account : CREATE TABLE , CREATE VIEW, CREATE PROCEDURE, CREATE TYPE , CREATE DATABASE LINK , CREATE TRIGGER, CREATE SESSION ; These are combined into two roles (with the exception of database link) as CONNECT, RESOURCE; So all i have to do is GRANT CONNECT, RESOURCE TO user;

    Do i have any equivalent in SQLServer2k5/8? Will db_datawriter be more than what one can ask for? I have created a Schema and has made it the default schema for the login ==> DbUser. I want this user account to be given Developer Rights.

    TIA

  • April 15, 2009 at 9:34 pm

    #978577

    db_datawriter won't be enough. This is the equivalent of GRANT UPDATE, INSERT, DELETE on every table to the user. It will not allow creation of triggers etc

    I am not sure of the correct equivalent but either db_owner or db_ddladmin should be what you need.

  • April 17, 2009 at 11:06 am

    #979846

    At the database level, we make developers members of db_ddladmin, db_datawriter, and db_datareader.

    db_ddladmin allows object creation, db_datawriter allows insert, update, & delete in all user tables, db_datareader allows select from all user tables.

    Greg

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply