ALTER ROLE (TSQL Statement)

adds or removes a member to the specified role, or changes the role name.

Syntax

ALTER ROLE role_name WITH NAME = new_name

ALTER ROLE role_name
{     ADD  MEMBER principal
    | DROP MEMBER principal
}

Arguments

role_name

is the role name.

NAME = new_name

is the new name of the role.

ADD MEMBER principal

adds principal (user or role) to the role.

DROP MEMBER principal

removes principal (user or role) from the role.

principal

is the user or role to add to the role, or remove from it.

Remarks

Only sa or dbo is allowed to execute this statement.

Examples

ALTER ROLE accountants WITH NAME = controlling;

ALTER ROLE controlling ADD  MEMBER john;
ALTER ROLE controlling DROP MEMBER omer;