sp_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
sp_MShasdbaccess
[ ; ]
None.
0
(success) or 1
(failure).
Execute permission is granted to the public role.