Week 8 Assignment DS

%37

%2

SafeAssign Originality Report Database Security - 201950 - CRN165 - Rucker • Week 8 Paper

%39Total Score: Medium risk Venkatesh Bodhupally

Submission UUID: 40525814-9431-94c4-d9c0-f0e650f34655

Total Number of Reports

1 Highest Match

39 % Venkatesh week 8 Assignment DS.docx

Average Match

39 % Submitted on

08/21/19 02:03 PM EDT

Average Word Count

584 Highest: Venkatesh week 8 Assignment D…

%39Attachment 1

Institutional database (6)

Student paper Student paper Student paper

Student paper Student paper Student paper

Internet (1)

academyit

Top sources (3)

Excluded sources (0)

View Originality Report - Old Design

Word Count: 584 Venkatesh week 8 Assignment DS.docx

3 2 6

5 4 7

1

3 Student paper 2 Student paper 6 Student paper

Source Matches (9)

academyit 63%

Student paper 66%

Student paper 70%

Student paper 65%

Student paper 79%

Student paper 65%

Student paper 100%

Running Head: NEW ROLES BY ORACLE 12C 1

ORACLE 12C NEW ROLES 4

NEW ROLES BY ORACLE 12C

Venkatesh Bodhupally

NEW ROLES BY ORACLE 12C “In 2012, a report by Data Breach Investigation found that there was the breaching of more than 1 billion database records globally between the years 2004 to 2011” (Essawi, & Chigurupati, 2017). Oracle 12c therefore emerged and advanced security solutions. Auditing can be defined as the

process where configured database actions are monitored and recorded both from database users as well as no database users. The users who are recognized by the client identifier attribute are the ones referred to as the No database users”. Oracle Database Real Application Security is used in auditing this type of user. This can be done basing on individual actions like the SQL type statement executed, or combined data which includes the user name, application among many others. Auditing configuration can be done for both failed and successful activities. Many benefits come from performing audits. To begin with, Auditing is very helpful in that it allows companies to account for the actions of individuals. This may include the actions that are taken and affects specific content. “It also acts as a deterrent of intruders from performing actions that are not appropriate basing on their accountability” (Daghighi, 2019). The auditors will be notified of any action that is performed by users who are not authorized, and lastly, it becomes easier monitoring and gathering specific activities in the database. “The two roles AUDIT_ADMIN and AUDIT_VIEWER was purposely introduced to manage audit policies like the defined auditing, housekeeping initiation, as well as maintaining the data audit retention” (Ravikumar, et al., 2017). These new roles would make it easier for viewing and analyzing data for security reasons. AUDIT_VIEWER to be specific is a role that is suited for the

external auditors. AUDIT_ viewer is useful when it comes to viewing and analyzing audit data. This role does not, however, allow for users to be able to enable

and disable auditing on their objects. AUDIT _ADMIN is mostly used by administrators. It is very useful when it comes to configuring, audits as well as administration of both unified and fine-grained policies. It is also very important that administrators can view, and analyze audit data work done primarily by security administrators. In ensuring accountability, before an auditor can be able to perform any audit, they are first of all given the audit _admin role. This now ensures that an auditor can be able to easily create, alter, enable, disable and drop audit policies as well as be able to manage the trail of the unified audit. These two new roles have helped

simplify the configuration of database auditing in oracle 12c. This is because they are required to administer unified auditing. Apart from giving security administrators to easily configure audit policies, it gives ease of administration and flexibility. It only the database users who have these two new roles who can get the maintenance of the audit trail. The users can also be able to configure auditing to administer fine-grained audits as well as unified audits.

References

Daghighi, A. (2019). Application of an Artificial Neural Network as a Third-Party Database Auditing System. Essawi, T. R., & Chigurupati, N. (2017). U.S. Patent No. 9,535,971. Washington, DC: U.S. Patent and Trademark Office. Ravikumar, Y. V., Krishnakumar, K. M., & Basha, N. (2017). Oracle Database Upgrade and

Migration Methods: Including Oracle 12c Release 2. Apress.

1

2

3

4

5

6

7 3 3

1

Student paper

NEW ROLES BY ORACLE 12C 1

Original source

Section 1 - New Features of Oracle Database 12c

2

Student paper

ORACLE 12C NEW ROLES 4 NEW ROLES BY ORACLE 12C

Original source

Introduction of two new roles Oracle database 12c Introduction of two new roles Oracle database 12c

3

Student paper

Auditing can be defined as the process where configured database actions are monitored and recorded both from database users as well as no database users. The users who are recognized by the client identifier attribute are the ones referred to as the No database users”. Oracle Database Real Application Security is used in auditing this type of user.

Original source

To start with, auditing is the monitoring and recording of configured database actions form both the users of the database as well as the database non- users The users who are accepted in the through the client _identifier attribute in the database are referred to as the non- database users Auditing this type of users unified audit policy condition or Oracle database real application security is used

4

Student paper

AUDIT_VIEWER to be specific is a role that is suited for the external auditors.

Original source

This AUDIT_VIEWER role can be only granted to External Auditors

5

Student paper

AUDIT_ viewer is useful when it comes to viewing and analyzing audit data.

Original source

AUDIT_VIEWER is for analyzing and viewing the audit data

6

Student paper

These two new roles have helped simplify the configuration of database auditing in oracle 12c.

Original source

Database Auditing and introduction of new roles in 12c to simplify auditing

7

Student paper

Patent and Trademark Office.

Original source

Patent and Trademark Office

Student paper 100%

Student paper 100%

3

Student paper

V., Krishnakumar, K. M., & Basha, N.

Original source

V., Krishnakumar, K M., & Basha, N

3

Student paper

Oracle Database Upgrade and Migration Methods: Including Oracle 12c Release 2.

Original source

Oracle Database Upgrade and Migration Methods Including Oracle 12c Release 2