NTLoginAccessType Property
Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.
The NTLoginAccessTypeproperty reports whether a Microsoft Windows login has explicit permissions to connect to a server.
Syntaxe
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. |
Notes
Use the Add or Remove methods of the Logins collection to manipulate user login records.