Post reply

Assign Database Roles

  • July 3, 2003 at 2:16 pm

    #81937

    How can I assign multiple database roles to an existing database user? Please help.

    Thank you in advance.

  • July 3, 2003 at 10:44 pm

    #464158

    In EM, expand the database and the users, right-click on the user, select properties and then just check each role that you want assigned.


    Cheers,
    - Mark

  • July 5, 2003 at 3:32 am

    #464213

    For adding multiple db role to user, use procedure as

    sp_addrolemember @rolename,@membername

    Eg.

    sp_addrolemember 'db_datawriter','membername'

    Sachin Bhaygude


    Sachin Bhaygude

  • July 9, 2003 at 4:36 pm

    #464757

    Thanks. I guess I will have to issue the sp_addrolemember statement multiple times.

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

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