sp_MShasdbaccess (Transact-SQL)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

Lists the name and owner of all the databases to which the user has access.

Topic link icon Transact-SQL Syntax Conventions

Syntax

  
sp_MShasdbaccess      

Return Code Values

0 (success) or 1 (failure)

Permissions

Execute permission is granted to the public role.

See Also

sys.sysdatabases (Transact-SQL)