SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2012
Product Documentation
Books Online for SQL Server 2012
Database Engine
Transact-SQL Reference (Database Engine)
System Stored Procedures (Transact-SQL)
Security Stored Procedures (Transact-SQL)
sp_addapprole (Transact-SQL)
sp_addlogin (Transact-SQL)
sp_addremotelogin (Transact-SQL)
sp_addrole (Transact-SQL)
sp_addrolemember (Transact-SQL)
sp_addserver (Transact-SQL)
sp_addsrvrolemember (Transact-SQL)
sp_adduser (Transact-SQL)
sp_approlepassword (Transact-SQL)
sp_audit_write (Transact-SQL)
sp_change_users_login (Transact-SQL)
sp_changedbowner (Transact-SQL)
sp_changeobjectowner (Transact-SQL)
sp_control_dbmasterkey_password (Transact-SQL)
sp_dbfixedrolepermission (Transact-SQL)
sp_defaultdb (Transact-SQL)
sp_defaultlanguage (Transact-SQL)
sp_denylogin (Transact-SQL)
sp_dropalias (Transact-SQL)
sp_dropapprole (Transact-SQL)
sp_droplogin (Transact-SQL)
sp_dropremotelogin (Transact-SQL)
sp_droprole (Transact-SQL)
sp_droprolemember (Transact-SQL)
sp_dropserver (Transact-SQL)
sp_dropsrvrolemember (Transact-SQL)
sp_dropuser (Transact-SQL)
sp_grantdbaccess (Transact-SQL)
sp_grantlogin (Transact-SQL)
sp_helpdbfixedrole (Transact-SQL)
sp_helplinkedsrvlogin (Transact-SQL)
sp_helplogins (Transact-SQL)
sp_helpntgroup (Transact-SQL)
sp_helpremotelogin (Transact-SQL)
sp_helprole (Transact-SQL)
sp_helprolemember (Transact-SQL)
sp_helprotect (Transact-SQL)
sp_helpsrvrole (Transact-SQL)
sp_helpsrvrolemember (Transact-SQL)
sp_helpuser (Transact-SQL)
sp_migrate_user_to_contained (Transact-SQL)
sp_MShasdbaccess (Transact-SQL)
sp_password (Transact-SQL)
sp_remoteoption (Transact-SQL)
sp_revokelogin (Transact-SQL)
sp_revokedbaccess (Transact-SQL)
sp_setapprole (Transact-SQL)
sp_srvrolepermission (Transact-SQL)
sp_unsetapprole (Transact-SQL)
sp_validatelogins (Transact-SQL)
sp_xp_cmdshell_proxy_account (Transact-SQL)
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_MShasdbaccess (Transact-SQL)

SQL Server 2012

Lists the name and owner of all the databases to which the user has access.

Topic link icon Transact-SQL Syntax Conventions

Copy 
sp_MShasdbaccess

0 (success) or 1 (failure)

Execute permission is granted to the public role.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.