Resources
Collections
Providers

Hubs

Sign in to see your Hubs
Login
Featured Hubs
2022 OER Partner Summit
Open Textbooks
#GoOpen
Professional Learning
Climate Education
OERizona
See all Hubs

Groups

Sign in to see your Groups
Login
Featured Groups
Adult Education Open Community of Resources
OpenStax Biology 2e
PA STEM Toolkit
Pathways Project | Language Teaching Repository @ Boise State
Student Advocacy
See all Groups

Learn More

About
Help Center
About Hubs
Services
OER 101

Open Author

Create a standalone learning module, lesson, assignment, assessment or activity

Submit from Web

Submit OER from the web for review by our librarians

Add Link

Learn more about creating OER

Add OER

Add Link
About creating OER

Advanced Search

Sign In/Register

Please log in to save materials. Log in

Export to Google Docs
Report

Summary
Table of Contents

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.

title "Database" 2024 by Mumtaj Yasmin
under license"Creative Commons Attribution"

Version History

Cite this work

OVERVIEW

Unit 1 - Lesson Plan- Authentication

Unit 2- Lesson Plan - Profile

Unit 3- Lesson Plan - Authroization

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

Unit 5-Lesson Plan - Audit

Unit 6-Lesson Plan- Concurrency Control

Unit 7 - Lesson Plan- SQL Injection

Unit 8 - Lesson Plan - Encryption

Unit 9 - Lesson Plan - Oracle Label Security

Unit 1 Authentication

Unit Objective:

1.1 User Authentication

1.2 Basic authentication- Database user identified by a password

1.2.1. changing user password

1.3 Listing All Users Information

1.4 Assigning a Default Tablespace for the User

1.5 Assigning a Temporary Tablespace for the User

1.6 Assigning a Tablespace Quota for the User

1.7 Remove User Accounts

1.8 External Authentication

1.9 Proxy Authentication

1.9.1. Assign role to proxy user

1.9.2. Remove the connection of proxy user

1.9.3 Proxy user authenticated using password

Unit Summary

Practical Exercise 1-Database User

Exercise 2 - Proxy user

2.4 Display Resource Limits of the Profile

2.5 Password_Life_Time

2.5.1 Account Status is Expired

2.5.2 Change Password Expiry date

2.6 Password_Grace_Time

2.7 Account Status Message

2.8 FAILED_LOGIN_ATTEMPTS and PASSWORD_LOCK_TIME

2.8.1 Account Status Lock

2.9 Modify profile parameter Default Value settings

2.10 Password_Reuse_Max

2.11 Password_Reuse_Time

2.11.1 Password_Reuse_time vs. Password_Reuse_max values

2.12 Password Expire

2.13 Password_Verify_Function

2.14 Last Modified password Date/time

2.15 Password Case Sensitive

3.3 Functionality of Roles

3.4 Type of Role Authorization

3.5 Change the authorization method

3.6 Drop Role

3.7 Authorization of Object privilege

3.8 With GRANT option Vs. with ADMIN option

3.9 Data Dictionary view of DBA_TAB_PRIVS

3.9.1 Grantor, Grantee and Owner

3.10 Granting Column Privileges

3.11 ALL Shortcut

3.12 SYNONYM Object Privilege

Unit 4 Virtual Private Database

Unit Objective

4.1 Introduction

4.2 Components of an Oracle Virtual Private Database Policy

4.2.1. Create Function

4.3 Creating a Policy to Attach the Function to the Objects

4.8 Oracle Virtual Private Database Policy Types

4.9 Application Context

5.2 Auditing Activities

5.3 Authorization to perform Audit

5.4 Audit Trail

5.5 ENABLE AUDIT

5.6 Auditing Statement Executions

5.7 Audit Option

Audit return codes

5.8 Standard Auditing Levels

5.8.1 Statement level

5.8.2 Object Level

5.8.3. Privilege Auditing

5.9 FGA AUDIT POLICY

5.10 Remove FGA Policy

Lecture Notes For Unit-5

References

Unit 6 Concurrency and Locking

Unit Objective:

6.1 Concurrency Control

6.2 Locking

6.3 Lock Modes

6.4 Oracle Automatic Locking Categories

Lecture Notes For Unit-6

Lecture Notes For Unit-7

Questions

References

Unit 8 Encryption and Wallet

Unit Objective:

8.1 Introduction of Transparent Data Encryption (TDE)

8.2 Encryption Components

8.3 Encryption and Decryption Process

8.4 Create Wallet

8.5 Create Master key

8.5.1 Open the Wallet

8.5.2 Status of the Wallet

8.5.3 Close the Wallet

8.6 Creating a Table with an Encrypted Column

8.6.1 Salt

8.7 Encryption Algorithms for TDE

8.8 Disabling Encryption on a Column

8.9 Adding Encrypted Columns to Existing Tables

8.10 Create an Encrypted Tablespace

Unit 8- Exercise

Video Tutorial Link

Lecture Notes For Unit-8

Questions

References

Unit 9 Oracle Label Security

Database

Created May 23, 2024 by Mumtaj Yasmin

Remixed from "Database Security" by Girija Narasimhan

Return to top

Subject:: Career and Technical Education
Level:: College / Upper Division, Graduate / Professional, Career / Technical
Material Type:: Full Course

Standards

No Alignments yet.

Delete Resource?

Cite this work

MLA
APA

Yasmin, Mumtaj. "Database". OER Commons. Institute for the Study of Knowledge Management in Education, 17 Oct. 2018. Web. 07 Nov. 2024. <https://oercommons.org/authoring/48962-database>.

Yasmin, M. (2018, October 17). Database. OER Commons. Retrieved November 07, 2024, from https://oercommons.org/authoring/48962-database.

copy citation

History

Remixed from:
"Database Security" 2024 by Girija Narasimhan

Discover

Resources
Collections
Providers

Community

All Hubs
All Groups

Create

Submit a Resource

Our Services

About Hubs
About OER Commons
OER 101
Help Center

My Account

My Items
My Groups
My Hubs

Subscribe to OER Newsletter

Connect with OER Commons Facebook, Opens in new window Twitter, Opens in new window

Donate to ISKME

Powered By

Privacy Policy Terms of Service Collection Policy DMCA

A project created by ISKME. Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 License.