Database Administration and Security

A management role responsible for controlling corporate data resources (both computerized and manual).

A role responsible for maintaining a successful database environment, including design, implementation, maintenance, and security.

DBMS features and measures to protect organization's data and system against threats.

Provides a syntax for specifying security restrictions within a database system.

People or programs interacting with and performing actions on database objects.

To define the logical boundaries and contents of the database.

To design, implement, maintain, and manage the physical structure (databases).

Protects against data loss, corruption, mishandling, & service degradation, protecting data privacy and business integrity.

DA focuses on business needs (logical database design) and policies; DBA focuses on technical aspects (physical database management and maintenance).

Supporting end-users, defining/enforcing database policies, providing backup and recovery, and monitoring data.

Elements like rows, columns, tables, indexes, and views that users can manipulate within a database.

Rights granted to users to perform actions (select, insert, delete, update) on database objects.

Named collections of privileges that authorize users to access and use specific database resources.

First steps to secure access to the SQL server instance (and database); verifying user identity and controlling their permissions.

Logins (server level) and users/roles (database level) grant access to the SQL server.

DA and DBA roles can sometimes overlap, especially when an organization doesn't have a DA, with DBA handling some of DA's duties.

Connections to SQL Server services, requiring mapped database users for object access.

Authorizations given to database users to control access to database objects.

SQL command to provide access privileges on database objects to users.

SQL command to remove user privileges on database objects.

Connecting server-level logins to database users for access.

A particular SQL Server service.

Elements in a database that users modify (tables, data etc.).

The privileges granted to a user to modify a database or its contents.

SQL command to create a login account for accessing the SQL Server.

SQL command to grant select and update permissions on a specific table to a user.

SQL command used to remove update permissions from a user on a specific table.

SQL command to modify a login account's details like Name or Password.

SQL command to create a user within a specific database using a login.

A named collection of privileges for accessing the database resources.

A server-level account used to authenticate users for database access.

Security mechanisms in SQL Server for controlling access to database objects.

Predefined or custom roles in a database that assign privileges to users.

A fixed database role allowing complete database management, including configuration, maintenance and dropping the database.

A fixed database role that prevents users from reading data in user tables.

Roles created by the user based on their needs, offering specific permissions to users.

The process of assigning a user to a database role granting the associated privileges.

The specific SQL command to add a user to the db_owner role.

The specific actions allowed by the predefined database role.

Members of the db_denydatareader role cannot access data in user tables.

This fixed database role allows modifying role memberships for custom roles and managing permissions.

This fixed database role manages database access for Windows logins, Windows groups, and SQL Server logins.

This fixed database role allows backing up the database.

This fixed database role executes Data Definition Language (DDL) commands.

This fixed database role permits adding, deleting, or changing data in user tables.

This fixed database role allows reading data from user tables.

This fixed database role prohibits adding, modifying, or deleting data in user tables.

A named set of privileges that control user access to database resources.