sp_MShasdbaccess (Transact-SQL)
Lists the name and owner of all the databases to which the user has access.
.gif "Topic link icon")
Syntax
sp_MShasdbaccess
Return Code Values
0 (success) or 1 (failure)
Permissions
Execute permission is granted to the public role.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Lists the name and owner of all the databases to which the user has access.
sp_MShasdbaccess
0 (success) or 1 (failure)
Execute permission is granted to the public role.