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

Summary

Database Security is the utmost key part for any type of database, .for example financial information, personal information, employee information and enterprise information. This book will cover following topics such as creating and altering database user, password profiling, various privileges and virtual private database. All the topics are implemented by using oracle 11g software. Especially for readers this book will give clarity about database security concepts such as Authorization, Authentication and Access control. The practical part using oracle provides how to carry out database security concepts technically for the reader.