Done. Implementing Security and Auditing Oracle Database 12c

Flashcards covering key concepts, definitions, and functionalities related to securing and auditing an Oracle Database 12c.

CREATE USER

A SQL statement used to create a new database user account.

ALTER USER

A SQL statement used to modify an existing user account's properties.

GRANT

A SQL command used to give privileges to users or roles.

REVOKE

A SQL command used to remove privileges from users or roles.

Password Authentication

A method where the user's identity is confirmed by their username and password.

Externally Authenticated User

A user whose identity is verified by the operating system, bypassing database password checks.

Globally Authenticated User

A user authenticated through an external service, allowing for different authentication methods.

Roles

Named groups of privileges assigned to users in Oracle Database.

Profiles

Database constructs that define limits and attributes for user accounts, including password rules.

Tablespace Quotas

Limits on the amount of space a user can consume in a specific tablespace.

Auditing

The process of monitoring and recording database actions to ensure compliance and security.

Standard Auditing

Traditional auditing features in Oracle allowing specific SQL statements or privilege references to be logged.

Unified Auditing

A new approach to auditing in Oracle Database 12c that consolidates audit records into a single view.

Database links

Database objects that allow sharing of data between different Oracle databases.

SYSDBA

A special administrative user with unrestricted database management capabilities.

SQL Developer

A graphical tool for managing Oracle databases and developing applications.

Resource Limits

Constraints applied to user sessions for managing resources such as CPU, memory, and disk space.

Object Privileges

Permissions on specific database objects like tables, views, and procedures.

System Privileges

Permissions to perform specific actions at the database level.

User Account Policies

Rules that define password history, expiration, and failure attempts for user accounts.

Fine-Grained Auditing (FGA)

A method of auditing that allows for specific control over what gets logged based on data content.

Data Dictionary

The set of database views and tables that contain metadata about the database structure.

Account Locking Policy

A security feature that locks user accounts after a specified number of failed login attempts.

Temporary Tablespace

A tablespace used for sorting operations and for temporary storage of data.