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.

Applies To: