sp_changegroup

Description

Changes a user’s group.

Syntax

sp_changegroup grpname, username

Parameters

grpname

is the name of the group. The group must already exist in the current database. If you use “public” as the grpname, enclose it in quotes, because it is a keyword.

username

is the name of the user to be added to the group. The user must already exist in the current database.

Examples

Example 1

The user “albert” is now a member of the “fort_mudge” group. It doesn’t matter what group “albert” belonged to before:

sp_changegroup fort_mudge, albert

Example 2

Removes “albert” from the group he belonged to without making him a member of a new group (all users are always members of “public”):

sp_changegroup "public", albert

Usage

Permissions

The permission checks for sp_changegroup differ based on your granular permissions settings.

Granular permissions enabled

With granular permissions enabled, you must be a user with manage any user privilege.

Granular permissions disabled

With granular permissions disabled, you must be the database owner, a user with sa_role, or a user with sso_role.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Event

Audit option

Command or access audited

Information in extrainfo

38

exec_procedure

Execution of a procedure

  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

  • Proxy information – Original login name, if set proxy in effect

See also

Commands grant, revoke

System procedures sp_addgroup, sp_adduser, sp_dropgroup, sp_helpgroup