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.