Demonstrate the audit of the specific privileges

Assignment Help Database Management System

Reference no: EM131833220

Homework - Auditing Oracle DB Objects

Overview: This homework provides an opportunity for the student to create Oracle 12 C audit policies to help better secure sensitive data stored in Oracle database tables.

Assignment: Using the information and examples provided in the readings for week 7 and 8, create a test user and associated policies and test scenarios to audit the test user against the following privileges (available in the system_privilege_map Oracle 12C object):

1. Create Any Table

2. Drop Any Table

3. Create User

4. Drop User

5. Update any Table

The following are some additional guidance, requirements and hints for this assignment:

a. Create a test user named SDEV350User with access to unlimited space on the User's table space.

b. Allow the SDEV350User to be able to create sessions, create any table, drop any table, create users, drop user, and update any table.

c. Create policies for each of the 5 possible privileges.

d. Create test scenarios (e.g. SQL scripts that you can run) that will demonstrate the audit of the specific privileges is taking place.

e. Provide the specific results of running the test scenarios and explain the output of each query.

f. Discuss how this type of audit policy could help protect the integrity of the database.

g. Provide detailed, step-by-step instructions on how to run your SQL scripts and test scenarios.

Be sure your SQL scripts work perfectly and your supporting documentation is neat, well-organized and well-written.

Deliverables:

1. Create a word or PDF document that describes your process, steps and results. Be sure to describe your schema and the queries you are using for your application. Provide screen shots showing the successful running of all of your SQL statements and testing your scenarios. Be sure your testing is comprehensive demonstrating all functionality. The document should be neat, well-organized, well-written and contain minimal grammar and spelling errors.

2. A single SQL script file that contains all of the SQL statements used to set-up and run the test scenarios. Be sure to include the connection statements as well as often the sys account would need to run. Clearly, define with SQL statements and comments which user is running which SQL statements.

Reference no: EM131833220

Questions Cloud

Review problem on financial bubble : When a financial bubble collapses, is that more like a fall in aggregate demand or a fall in the potential growth rate?

Discuss the different type of shock : Central banks and voters alike usually want higher real growth and lower inflation. What kind of shock makes that happen?

What are the variables and how are they measured : Identify potential internal and external validity issues in the conclusions drawn by the author(s).What are the variables and how are they measured?

How to prevent the bad outcome in the first place : The Fed plays an important role in maintaining market confidence. As former Chairman Alan Greenspan put it in a 1997 address.

Demonstrate the audit of the specific privileges : SDEV 350 Homework - Auditing Oracle DB Objects. Create test scenarios that will demonstrate the audit of the specific privileges is taking place

How does change the Fed response to economic shocks : If velocity does tend to move in the direction of money growth, how does this change the Fed's response to economic shocks: Should it take bigger moves.

Determining the effect of both inflation and real growth : We saw that real shocks and AD shocks often occur simultaneously. When this happens, unless we know the exact size of each shock.

What will the velocity shock do to real growth : One argument for giving discretion to central bankers is that sometimes emergencies come along that a simple rule can't solve.

How fast the money supply should grow : Practice with the best case: You are the central banker, and you have to decide how fast the money supply should grow. Your economy gets hit by the following.

Reviews

len1833220

1/26/2018 11:38:32 PM

This homework provides an opportunity for the student to create Oracle 12 C audit policies to help better secure sensitive data stored in Oracle database tables. Audit Policy - Creates a test user named SDEV350User with access to unlimited space on the User's tablespace. (10 points) Allows the SDEV350User to be able to create sessions, create any table, drop any table, create users, drop user, and update any table. (10 points) Creates policies for each of the 5 possible privileges. (15 points) Creates test scenarios (e.g. SQL scripts that you can run) that will demonstrate the audit of the specific privileges is taking place. (20 points) Provide the specific results of running the test scenarios and explain the output of each query. (10 points) Discusses how this type of audit policy could help protect the integrity of the database. (5 points) Provides detailed, step-by-step instructions on how to run your SQL scripts and test scenarios. (5 points).

len1833220

1/26/2018 11:38:26 PM

Documentation and submission - Creates a word or PDF document that describes your process, steps and results. (5 points) Describes your schema and the queries you are using for your application. (2 points) Provides screen shots showing the successful running of all of your SQL statements and testing your scenarios. (3 points) The document should be neat, well-organized, well-written and contain minimal grammar and spelling errors. (5 points) Includes a single SQL script file that contains all of the SQL statements used to set-up and run the test scenarios. (5 points) Includes the connection statements as well as often the sys account would need to run. (3 points) Clearly defines with SQL statements and comments which user is running which SQL statements. (2 points)

Write a Review

Required(*) Message

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages