Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 NTLoginAccessType property 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.