IsNTGroupMember Method

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The IsNTGroupMember method exposes an instance of Microsoft SQL Server access rights for Windows user accounts.

Syntax

object
.IsNTGroupMember(
NTGroup , NTUser)asBoolean

Parts

  • object
    An expression that evaluates to an object in the Applies To list.

  • NTGroup
    A string that names a Windows group account granted login access to an instance of SQL Server.

  • NTUser
    A string that names a Windows user account.

Prototype (C/C++)

HRESULT IsNTGroupMember(SQLDMO_LPCSTR NTGroup,
SQLDMO_LPCSTR NTUser, LPBOOL pRetVal);

Returns

TRUE when the user identified is a member of the NT group. FALSE otherwise.

Remarks

Use the IsNTGroupMember method to discover access rights for a Windows user when login access is granted to Windows group accounts.

When a Windows security account is granted or denied access to an instance of SQL Server, an entry exists in syslogins. The SQL Distributed Management Objects (SQL-DMO) Logins collection will expose a member referencing the security account. When a syslogins record, or Login object, references a Windows group account, individual records and objects are not created referencing group members.

Applies To: