Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Lists the name and owner of all the databases to which the user has access.
Transact-SQL syntax conventions
Syntax
sp_MShasdbaccess
[ ; ]
Arguments
None.
Return code values
0 (success) or 1 (failure).
Permissions
Execute permission is granted to the public role.