NTLoginAccessType Property
В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.
The NTLoginAccessTypeproperty reports whether a Microsoft Windows login has explicit permissions to connect to a server.
Синтаксис
object..NTLoginAccessType
Parts
- object
An expression that evaluates to an object in the Applies To list
Data Type
Long integer
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetNTLoginAccessType (SQLDMO_NTACCESS_TYPE *pRetVal);
Settings
Interpret the NTLoginAccessType property return value using these SQLDMO_NTACCESS_TYPE values.
Constant |
Value |
Description |
|---|---|---|
SQLDMONTAccess_Deny |
2 |
This login has explicit deny permissions to access this server. |
SQLDMONTAccess_Grant |
1 |
This login has explicit grant permissions to access this server. |
SQLDMONTAccess_NonNTLogin |
99 |
The login is a standard SQL Server login; the property does not apply. |
SQLDMONTAccess_Unknown |
0 |
The login has not been explicitly granted or denied permissions to access this server. The login may still have access through a group membership, but this is not recorded as a login property. |
Замечания
Use the Add or Remove methods of the Logins collection to manipulate user login records.