Eksportuj (0) Drukuj
Rozwiń wszystko
Ta zawartość nie jest dostępna w wymaganym języku. Wersja w języku angielskim znajduje się tutaj.

IS_MEMBER (Azure SQL Database)

Updated: November 21, 2014

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

This topic is not maintained. For the current version, see IS_MEMBER.

Indicates whether the current user is a member of the specified SQL Server database role.  

Syntax Conventions (Azure SQL Database)

IS_MEMBER ('role')

Is the name of the SQL Server role that is being checked. The role is the sysname and can include the database-fixed roles or user-defined roles, but not server roles.

This syntax diagram demonstrates the supported arguments in Microsoft Microsoft Azure SQL Database.  

Microsoft Azure SQL Database does not support the group argument when using the IS_MEMBER statement. If a Microsoft Windows group is specified, this statement returns NULL.


Return Value Description


Current user is not a member of the specified role.


Current user is a member of the specified role.


The specified role is not valid.

For more information about the arguments and the IS_MEMBER statement, see IS_MEMBER in SQL Server Books Online.

© 2014 Microsoft