This topic has not yet been rated - Rate this topic

IsNTGroupMember Method

SQL Server 2005

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:

SQLServer Object

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD