Database security

02/07/2020 Originality Report

https://blackboard.nec.edu/webapps/mdb-sa-BB5b75a0e7334a9/originalityReport/ultra?attemptId=c2ea755f-b4e6-405c-8b5a-edf4423b90e9&course_id=_48136… 1/4

%40

%7

%4

SafeAssign Originality Report Database Security - 202031 - CRN221 - Zavgren • Week 8 Paper

%50Total Score: High riskDivya Shanthipuram Pandurangan Submission UUID: 81daffa8-3488-595b-4ddb-c05baba35b93

Total Number of Reports

1 Highest Match

50 % New Auditing Roles in Oracle 12c.docx

Average Match

50 % Submitted on

07/02/20 11:11 PM CDT

Average Word Count

646 Highest: New Auditing Roles in Oracle 1…

%50Attachment 1

Institutional database (3)

Student paper Student paper Student paper

Global database (2)

Student paper Student paper

Internet (3)

com usakochan pearson

Top sources (3)

Excluded sources (0)

View Originality Report - Old Design

Word Count: 646 New Auditing Roles in Oracle 12c.docx

3 1 2

5 4

7 8 6

3 Student paper 5 Student paper 4 Student paper

02/07/2020 Originality Report

https://blackboard.nec.edu/webapps/mdb-sa-BB5b75a0e7334a9/originalityReport/ultra?attemptId=c2ea755f-b4e6-405c-8b5a-edf4423b90e9&course_id=_48136… 2/4

Source Matches (14)

Student paper 76%

Student paper 100%

Student paper 73%

1

DATABASE SECURITY 4

New Auditing Roles in Oracle 12c

Student’s Name: Divya Shanthipuram Pandurangan Institutional Affiliation: New England College

Date: 07/02/2020

Oracle 12c has recently introduced two important features that have enhanced the auditing process within system databases. AUDIT_ADMIN and AU-

DIT_VIEWER features are particularly used to separate the roles of users of system databases. According to Blake “AUDIT_ADMIN gives absolute rights to a data- base administrator to perform various data manipulation activities on a schema” (Blake, 2017). AUDIT_VIEWER, on the other hand, is used to allow users to ana- lyze and manage audit data. These roles have improved the effectiveness of the auditing process which has also improved the database security. Auditing refers to processes that manage and records the activities being carried out in the database. It provides an opportunity for both users and non-users to access the database systems. Database administrators are mandated to take the responsibility of setting up a program that can be used to monitor and manage activities performed in the database systems (Farooq, Avantsa & Sharman, 2016). However, it is always under the jurisdiction of the database security managers to man- age the auditing programs. The database security managers are mandated with the responsibility to authorize any client who wishes to access the database sys- tem by granting them access rights to the systems. However, to monitor the activities carried out by a non-user in the database system, a unified approach to se- curity is used. The new features of the Oracle 12c are used to provide the best auditing programs that help companies handle both authorized and unauthorized users of the databases (Blake, 2017). Therefore, auditing is primarily used to promote accountability by controlling access to the databases through verification. It also monitors all activities happening on a system database. The Oracle 12c primarily introduced these features to enhance the security of the databases.

This is achieved by recording the clients’ details and data to its security details. Therefore, all security efforts in the databases are focused on improving the cred- ibility and consistency of the activities carried out in the database system. Typically, “a well-designed audit program can detect intruders to a system and

quickly deter wrongful data manipulation” (Farooq, Avantsa & Sharman, 2016). In case there is an illegal manipulation, AUDIT_ADMIN is used to detect and pre- vent the unlawful changes of data within the databases. Oracle 12c Audit programs are used by most companies to inform the administrators of any strange op- erations happening in the database systems. All strange activities can be detected following the order of occurrence and the time of occurrence (Farooq, Avantsa & Sharman, 2016). For example, they can be detected from deleting tables, or changing the rows and manipulating files. In some other cases, the audit pro-

gram can be used to inform the administrators of the unusual activities happening in the database. “Every client needs Audit-viewer rights to perform specific actions on the schema” (Gaetjen, Knox &Maroulis, 2017). However, if these rights go overboard, the audit program should inform the managers of such action. The role of auditing programs involves recording all activities occurring in the system database. When registered personnel of database security are employed by the company, he or she is given the responsibility of analyzing the past vents in the database (Gaetjen, Knox &Maroulis, 2017). This involves checking whether there is any suspicious activity recorded by the audit program. Operations of linking several plans including table updating may be performed by both autho- rized and the unauthorized.

References: 1. Blake, E. (2017). Network and Database Security: Regulatory Compliance, Network, and Database Security - A Unified Process and Goal.

Journal Of Digital Forensics, Security And Law. 2. Farooq, T., Avantsa, S., & Sharman, P. (2016).Building Database Clouds in Oracle 12c. Addi-

son-Wesley Professional. 3. Gaetjen, S., Knox, D., &Maroulis, W. (2017). Oracle Database 12c Security. McGraw-Hill E Education Group.

1

2

3

3

3

3

4 5

4 6 7 8

3 3

1

Student paper

DATABASE SECURITY 4

Original source

Database Security Week-4 Paper

2

Student paper

New England College

Original source

New England College

3

Student paper

Oracle 12c has recently introduced two important features that have enhanced the auditing process within system databases. AUDIT_ADMIN and AU- DIT_VIEWER features are particularly used to separate the roles of users of system databases. According to Blake “AUDIT_ADMIN gives absolute rights to a database administrator to perform various data manipulation activities on a schema” (Blake, 2017).

Original source

Oracle 12c recently rolled out two cru- cial features that have dramatically en- hanced the auditing process in a system database AUDIT_ADMIN and AU- DIT_VIEWER features are specifically meant to separate the roles of various users in the system platform Green- wald, Stackowiak & Stern (2013) explain that AUDIT_ADMIN gives absolute rights to a database administrator to perform various data manipulation activities on a schema

02/07/2020 Originality Report

https://blackboard.nec.edu/webapps/mdb-sa-BB5b75a0e7334a9/originalityReport/ultra?attemptId=c2ea755f-b4e6-405c-8b5a-edf4423b90e9&course_id=_48136… 3/4

Student paper 71%

Student paper 72%

Student paper 65%

Student paper 100%

Student paper 100%

Student paper 100%

pearson 75%

com 90%

usakochan 100%

3

Student paper

The Oracle 12c primarily introduced these features to enhance the security of the databases. This is achieved by recording the clients’ details and data to its security details.

Original source

Oracle 12C introduced these new fea- tures specifically to enhance database security details and data is particular to its security details

3

Student paper

Typically, “a well-designed audit pro- gram can detect intruders to a system and quickly deter wrongful data manip- ulation” (Farooq, Avantsa & Sharman, 2016). In case there is an illegal manipu- lation, AUDIT_ADMIN is used to detect and prevent the unlawful changes of data within the databases.

Original source

Typically, a well-designed audit program can detect intruders to a system and quickly deter wrongful data manipula- tion (Gaetjen, Knox, & Maroulis, 2015) For the case of illegal data manipula- tion, AUDIT_ADMIN rights can detect and prevent further unlawful data changes even with the database administrators

3

Student paper

For example, they can be detected from deleting tables, or changing the rows and manipulating files.

Original source

Strange actions may be detected in the order of occurrence and period, for in- stance, der deleting of tables, changing of rows of or manipulating files

4

Student paper

Network and Database Security:

Original source

Network and database security

5

Student paper

Regulatory Compliance, Network, and Database Security - A Unified Process and Goal.

Original source

Regulatory compliance, network, and database security – A unified process and goal

4

Student paper

Journal Of Digital Forensics, Security And Law.

Original source

Journal of digital forensics, security and law

6

Student paper

Farooq, T., Avantsa, S., & Sharman, P.

Original source

Avantsa / Farooq / Sharman

7

Student paper

(2016).Building Database Clouds in Ora- cle 12c.

Original source

Building Database Clouds in Oracle 12c

8

Student paper

Addison-Wesley Professional.

Original source

Addison-Wesley Professional

02/07/2020 Originality Report

https://blackboard.nec.edu/webapps/mdb-sa-BB5b75a0e7334a9/originalityReport/ultra?attemptId=c2ea755f-b4e6-405c-8b5a-edf4423b90e9&course_id=_48136… 4/4

Student paper 100%

Student paper 100%

3

Student paper

Gaetjen, S., Knox, D., &Maroulis, W.

Original source

Gaetjen, S., Knox, D., & Maroulis, W

3

Student paper

Oracle Database 12c Security. McGraw- Hill E Education Group.

Original source

Oracle Database 12c Security McGraw- Hill E Education Group