Database
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