SQL-DMO

HasDBAccess Property

The HasDBAccess property reports whether a user has explicit permissions to access a database.

Applies To
User Object

Syntax

object.HasDBAccess

Parts

Object

Expression that evaluates to an object in the Applies To list

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetHasDBAccess (LPBOOL pRetVal);

Remarks

After a connection is established to Microsoft® SQL Server™, an application can use the HasDBAccess property to determine whether a user has explicit access to a particular database. If HasDBAccess returns FALSE, the user does not have access. Use the Grant, Deny, or Revoke methods to manipulate user database permissions.