Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todaysp_MShasdbaccess (Transact-SQL)
Applies to: 
SQL Server
Lists the name and owner of all the databases to which the user has access.
Transact-SQL syntax conventions
syntaxsql
sp_MShasdbaccess
[ ; ]
None.
0 (success) or 1 (failure).
Execute permission is granted to the public role.