Security Catalog Views (Transact-SQL)

  • Article

Security information is exposed in catalog views that are optimized for performance and utility. When possible, use the following catalog views to access catalog metadata.

Database-Level Views

sys.database_permissions

sys.database_role_members

sys.database_principals

sys.master_key_passwords

Server-Level Views

sys.server_permissions

sys.sql_logins

sys.server_principals

sys.system_components_surface_area_configuration

sys.server_role_members

  

Encryption Views

sys.asymmetric_keys

sys.crypt_properties

sys.certificates

sys.key_encryptions

sys.credentials

sys.symmetric_keys

See Also

Reference

Catalog Views (Transact-SQL)

Other Resources

Security Considerations for SQL Server

Help and Information

Getting SQL Server 2005 Assistance