HAS_DBACCESS

Returns information about whether the user has access to the specified database.

Syntax

HAS_DBACCESS ( 'database_name' )

Arguments

database_name

Is the name of the database for which the user wants access information. database_name is sysname.

Return Types

int

Remarks

HAS_DBACCESS returns 1 if the user has access to the database, 0 if the user has no access to the database, and NULL if the database name is invalid.