IsNTGroupMember Method
В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.
The IsNTGroupMember method exposes an instance of Microsoft SQL Server access rights for Windows user accounts.
Синтаксис
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.
Замечания
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.