IS_ROLEMEMBER#
Indicates whether a specified database principle is a member of the specified database role.
Syntax#
IS_ROLEMEMBER ( 'role' [ , 'database_principal' ] )
Arguments#
‘role’
Is the name of the Querona role that is being checked. role is sysname.
‘database_principal’
Is the name of the database user, database role, or application role to check. database_principal is sysname, with a default of NULL. If no value is specified, the result is based on the current execution context. If the parameter contains the word NULL will return NULL.
Return types#
int
Examples#
IF IS_ROLEMEMBER ('db_datareader') = 1
SELECT CarNo FROM dbo.Cars;