Post reply

db_datareader + db_datawriter + CREATE PROC + ALTER PROC

  • January 31, 2011 at 3:34 am

    #244390

    How can we give below rights to user on one SCHEMA (dbo).I have a request to create a database role with permissions to create and

    update stored procedures and functions but not change the table definition,

    keys, indexes, and triggers.

    db_datareader + db_datawriter + CREATE PROC + ALTER PROC

    please help

    Abhijit - http://abhijitmore.wordpress.com

  • January 31, 2011 at 4:24 am

    #1280321

    reader and wirter can be given to a user from database role.

    To give permission of execute on all/specific SP, you can give 'grant exec' permission on all/specific SP.

    ----------
    Ashish

  • January 31, 2011 at 5:33 am

    #1280345

    Thanks I got the solution earlier.

    Abhijit - http://abhijitmore.wordpress.com

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

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