Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
22 Cards in this Set
- Front
- Back
|
sys.database_permissions
|
returns a row for every permission or column-exception permission in the db. For columns there is a row for every permission that is different from the corresponding object-level permission.
|
|
|
sys.database_role_members
|
returns one row fore each member of each database role
|
|
|
sys.database_principals
|
returns a row for each security principal in a database
|
|
|
sys.master_key_passwords
|
returns a row for each db master key password added by using the sp_control_dbmasterkey_password sp.
|
|
|
sys.server_permissions
|
returns on row for each server-level permission
|
|
|
sys.sql_logins
|
returns one row for every Sql server authentication login
|
|
|
sys.server_principals
|
contains a row for every server-level principal. contains is_disabled column
|
|
|
sys.system_components_surface_area_configuration
|
returns one row for each executable system object that can be enabled or disabled by a surface area configuration component.
|
|
|
sys.server_role_members
|
returns one row for each member of each fixed and user-defined server role
|
|
|
sys.asymmetric_keys
|
returns a row for each asymmetric key
|
|
|
sys.crypt_properties
|
returns one row for each cryptographic property associated w/ a securable
|
|
|
sys.certificates
|
returns a row for each certificate in the database
|
|
|
sys.key_encryptions
|
returns a row for each symmetric key encryption specified by using the ENCRYPTION BY clause of the CREATE SYMMETRIC KEY statement
|
|
|
sys.credentials
|
returns one row for each credential
|
|
|
sys.symmetric_keys
|
returns one row for every symmetric key created w/ the CREATE SYMMETRIC KEY statement
|
|
|
sys.cryptographic_providers
|
returns one row for each registered cryptographic provider
|
|
|
sys.server_audits
|
contains one row for each sql server audit in a server instance
|
|
|
sys.server_file_audits
|
contains extended info about the file audit type in a sql server audit on a server instance
|
|
|
sys.server_audit_specifications
|
contains info about the server audit specs in a sql server audit on a server instance
|
|
|
sys.server_audit_specifications_details
|
contains info about the server audit specs details (actions) in a sql server audit on a server instance
|
|
|
sys.database_audit_specifications
|
contains info about the database audit specs in a sql server audit on a server instance
|
|
|
sys.database_audit_specifications_details
|
contains info about the db audit specs in a sql server audit on a server instance for all databases
|
