Database Security (view)

Units included with this Open Author resource:

OVERVIEW

Learning goals:

This unit gives details of entire book unit plan

Unit 1 Authentication

Learning goals:

The reader get enhance practical knowledge about create, alter, drop user. The create User parameter such as default tablespace, temporary tablespace and Quota are explained. The readers can watch video related to this unit content and also practice exercise

Keywords:

CREATE USER, ALTER USER, DEFAULT TABLESPACE, TEMPORARY TABLESPACE, QUOTA, DROP USER

Unit 2  Profile

Learning goals:

This unit covers user profile and their parameters such as Failed_login_attempts, password_reuse_max, password_reuse_time, password_lock_time and password_life_time. This reader can watch related videos and practice exercises.

Keywords:

Alter Profile, CONNECT_TIME, Create Profile, DBA_PROFILES, FAILED_LOGIN_ATTEMPTS, IDEL_TIME, PASSWORD_GRACE_TIME, PASSWORD_LIFE_TIME, PASSWORD_LOCK_TIME, PASSWORD_REUSE_MAX, PASSWORD_REUSE_TIME, Security of Database, SESSION _PER_USER, Database Security, create user, ALTER USER, Authentication, Authorization, DBA_USERS, TEMPORARY TABLESPACE, DEFAULT PARMENATN TABLESPACE, DROP USER

Unit 3 Authorization

Learning goals:

This unit gives clarity to reader how to create roles and role functionality, system privilege and Object privilege

Keywords:

Authorization, Create Role, Database, Database Administration, Database Security, Dba_users, Dr.girija, Oracle 11g, Security Database, system privilege, object privilege, column privilege, ROLE_ROLE_PRIVS, DBA_TAB_PRIVS, Create synonym, create view, revoke, revoke all

Unit 4 Virtual Private Database

Learning goals:

This unit goal to explain creating virutal private database policy and attach the policy with function. Also implement Application context using virtual private database.

Keywords:

Database, Database Security, Dr.Girija Narasimhan, DROP USER, Oracle 11g, Policy, Revoke, Security Database, Security of Database, dr.girija, create policy, row level security, column masking, dbms_rls_add.policy, dbms_rls_drop.policy

Unit 5 Audit

Keywords:

Audit, standard audit, fine grain audit, statement level, previlege level

Unit 6 Concurrency and Locking

Unit 7  SQL Injection

Unit 8 Encryption and Wallet

Unit 9 Oracle Label Security