sys.sp_addrolemember

Description

Analytics Platform System (PDW) Adds a database user, database role, Windows login, or Windows group to a database role in The name of the database role in the current database. The security account being added to the role.

Syntax

sp_addrolemember
[ @rolename = ]
N
'rolename'
, [ @membername = ]
N
'membername'
[ ; ]

Arguments

database in Microsoft Fabric

Adds or removes members to or from a database role, or changes the name of a user-defined

database role.

Syntax for SQL Server (starting with 2012), Azure SQL Managed Instance, Azure SQL Database,

and Microsoft Fabric.

Syntax for SQL Server prior to 2012.

To add or drop members from roles in Azure Synapse Analytics and Analytics Platform

System (PDW) use