NTLoginAccessType Property
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 NTLoginAccessTypeproperty reports whether a Microsoft Windows login has explicit permissions to connect to a server.
Syntax
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. |
Remarks
Use the Add or Remove methods of the Logins collection to manipulate user login records.