Post reply

SP to modify using Datareader and datawriter

  • April 24, 2008 at 11:39 pm

    #154301

    HI,

    I have migrated 2000 database to 2005 database.

    oIn 2000 users able to modify the SP using db_datareader and db_datawriter accesss

    but in 2005 it is not possible,in 2005 db_ddl admin or db_ownere or db_security admin

    role is needed.,

    Could you please suggest is there any other method we can get the access

    What we need is to view the SP and modify the Sp

    sp_helptext not working with datareader and datawriter access

    Any suggestions

  • April 29, 2008 at 8:05 am

    #808369

    In my experience, db_datereader and db_datawriter were not enough to modify stored procedures in SQL 2000 unless the developer is the owner of the procedure. Our developers are members of db_ddladmin as well. If you don't want to give the the ability to alter any object in a database, you can grant ALTER PROCEDURE on each stored procedure that's created.

    Greg

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

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