Database Security

cover page

Unit 1 - Lesson Plan- Authentication

Basic Authentication-Create User - DBA_USERS - Default Tablespace - Temporary Tablespace - Quota - Revoke Quota - Unlimited Quota Value - Drop User Account

Unit 2- Lesson Plan - Profile

Create Profile - Alter profile - DBA_PROFILES - Password_Life_Time - Password_Reuse_Max  - Password_Reuse_Time  - Password_Lock_time - Password_Grace_Time  - Failed_Login_Attempts  - Drop Profiles - Display password change Date/Time - Account _status - Password Expire - Password_Case_sensitive - Password_Verify_Function

Unit 3- Lesson Plan - Authroization

Authorization-Role-Functionality of Roles-Type of Role Authorization-Change the authorization method-Drop Role-Authorization of Object privilege-With GRANT option Vs. with ADMIN option -Data Dictionary view of DBA_TAB_PRIVS – Column Privilege- Grant synonym privilege -  DBA_ROLE_PRIVS, - ROLE_ROLE_PRIVS

Unit 4-Lesson Plan- Virtual Private Database (VPD)

Virtual Private Database -Row Level Security (RLS) - Column Masking  - Application Context 

Unit 5-Lesson Plan - Audit

Audit activity-Standard Audit - Statement Level - Privilege Level - Object level - Fine Grain Audit

Unit 6-Lesson Plan- Concurrency Control

Concurrency control - shared mode- Exclusive Mode - Lock - Unlock

Unit 7 - Lesson Plan- SQL  Injection

Unit 8 - Lesson Plan - Encryption

Encryption - Encryption components - Encryption keys - Master key Creation - Wallet Opening and closing - Encryption Algorithm - Encryption Status - Decryption- Table Encryption - Table space Encryption

Unit 9 - Lesson Plan - Oracle Label Security