Post reply

Can''t add role as a member of another role anymore?

  • January 9, 2006 at 2:01 pm

    #152695

    In 2000, use to create a role like Developer and add it as a member to some of the fixed database roles.  That way I would only have to add the user once to the Developer role to give it the permissions I wanted to the database.

    2005 doesn't seem to allow you to add a role as a member of another role.  Is there another way to pass on the rights of a role to another role?

  • January 10, 2006 at 6:54 am

    #613789

    Add a database role, user, or windows user/group to a database role:

    sp_addrolemember @RoleName, @MemberName

     

     

  • January 10, 2006 at 7:05 am

    #613795

    Ok...that works.  Thanks. 

    Now why did they turn off that capability from Management Studio?  It won't even show the other roles so you can add them.  Spock and I find this very illogical! 

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

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