Server-level security (SLS)

 

The server level is the highest layer of security where the server admin manages privileges for server-level objects such as accounts, roles, and databases. Server Admin accounts manage server-level security (SLS) and always have all privileges at all levels. They can grant and revoke any privilege to any account and role. Typically server admin accounts grant or revoke SLS privileges to other accounts so those accounts can grant lower-level privileges. In smaller organizations server admin accounts may also perform the duties of database administrators.

SLS applies to all servers in a database cluster. SLS manages a cluster and all its servers, accounts, roles, and databases. Because accounts, roles, privileges, and their relationships are managed at the server level, they are stored centrally within a cluster and replicated across the cluster’s servers for high availability.

The authorization of accounts and the mapping of accounts to roles is often managed by an external system, such as LDAP, Active Directory, SAML, OAUTH, and so forth. The mapping of roles to object privileges is managed only within the cluster’s security system because only the cluster is aware of all its objects, privileges, and their mapping to each other.

Note Server administrators must be careful when granting privileges to another account since they could turn an account into a partial or full server-level administrator. 

 

Server objects

Account

Account objects can grant create, admin, delete, alter, reset, or impersonate privileges to other accounts. 

Note Each account name must be unique and cannot be changed. 

Privilege Description
Create The create account privilege enables an account to create other account objects. Creating an account makes you the owner of the new account. The owner has all privileges to manage the owned account including enabling, disabling, or deprecating it. The owner can also grant any or all of these privileges to other accounts. 
Admin The admin account privilege allows an account to give another account the admin ability. An account with the admin privilege can grant or revoke any or all privileges from the account(s) for which it is an admin. Thus, it can do all things that the owner of the account can do without being the owner.
Delete The delete account privilege allows an account to delete another account.
Alter The alter account privilege allows an account limited privileges to alter another account. An account with the alter privilege can disable, deprecate, and alter another accounts metadata. It does not grant delete, grant, reset, or impersonate privileges.
Reset The reset account privilege allows an account to reset the password of another account object. A reset will require the account's user to enter a new password the next time the authenticate. Passwords are never visible to anyone. Only the hash of the password is stored in the database. 
Impersonate The impersonate account privilege allows an account to impersonate specified accounts or all accounts belonging to a specific role. An account with the impersonate privilege cannot manage or alter the account it impersonates. An impersonator cannot alter, change the password, change the metadata, reset, or grant account privileges for the account it impersonates.

 

Role

Role objects can grant create, grant, delete, alter, or impersonate privileges to accounts. Roles exist at the server level or the database level and are unique within the level they are defined. This means that server-level roles are only used to defined the privileges assigned to server-level administrators to manage accounts, roles, and databases, whereas database-level roles are used to define the privileges assigned to database-level accounts. 

Privilege Description
Create The create role privilege allows the account to create a uniquely named role. The account that creates a role owns the role. The role owner can assign and remove accounts to and from the role, modify the role's metadata, delete the role, give the role's admin privilege to other accounts, and impersonate a role. 
Grant The grant role privilege allows an account to assign privileges to another account to manage a specific role or roles. 
Delete The delete role privilege allows an account to delete a role. Deleting a role immediately revokes its privileges from all accounts that have been assigned to that role. 
Alter The alter role privilege allows an account to add or remove accounts, privileges, and metadata from a role. An account with the alter privilege can add any account to a role, but can only add an object privilege to a role when it is a server administrator account or when it has the create or admin privilege for the objects. A role's name cannot be changed since that is its unique identifier. 
Impersonate The impersonate role privilege allows an account to temporarily behave as if it only had the privileges assigned to the role. 

 

Database

Database objects can grant the create and grant privileges to accounts. 

Privilege Description
Create The create database privilege allows an account to create a database with a unique database name. The account that creates a database owns the database and has all privileges for that database including privileges to modify the database's metadata, delete the database, or grant the admin privilege to other accounts. 
Grant The grant database privilege allows an account to have and grant database privileges to another account.