sp_MShasdbaccess (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse 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)