This topic has not yet been rated - Rate this topic

User.HasDBAccess Property

SQL Server 2012

Gets the Boolean property that specifies whether the database user has access to the database.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

C++

JScript

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool HasDBAccess { get; }

Property Value

Type: System.Boolean
A Boolean value that specifies whether the database user has access to the database.If True, the database user has access to the database.If False (default), the database user does not have access to the database.

Examples

Managing Users, Roles, and Logins

Reference

User Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Principals (Database Engine)

CREATE USER (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD