What are some of the private database cloud security issues

Assignment Help Database Management System

Reference no: EM131482881

Question :For this assignment you are required to do BOTH Part A and Part B

Part A

Submit short answers that discuss the following questions:

1. What are some of the private database cloud security issues and threats? How does this differ from the public database cloud environment?

2. What are the control issues specific to cloud computing in the public environment and service provider?

3. Develop an example of audit objectives in the cloud computing environment. How could these differ between a healthcare vs financial organization?

4. Develop an example of the quality assurance objectives.

Part B

Virtual Private Database by Views
This lab requires you to use Oracle VIEW to implement a virtual database on DBSEC schema, for example, on CUSTOMER table. Your task is to develop a single SQL script that will perform all the following tasks:
1. Connect to DBSEC/ IS481%sec, the same user you created in previous projects.
2. Create a CUSTOMER table with the following columns:
Column Name Data Type
SALES_REP_ID NUMBER(4)
CUSTOMER_ID NUMBER(8) NOT NULL
CUSTOMER_SSN VARCHAR2(9)
FIRST_NAME VARCHAR2(20)
LAST_NAME VARCHAR2(20)
ADDR_LINE VARCHAR2(80)
CITY VARCHAR2(30)
STATE VARCHAR2(30)
ZIP_CODE VARCHAR2(9)
PHONE VARCHAR2(15)
EMAIL VARCHAR2(80)
CC_NUMBER VARCHAR2(20)
CREDIT_LIMIT NUMBER
GENDER CHAR(1)
STATUS CHAR(1)
COMMENTS VARCHAR2(1024)
USER_NAME VARCHAR2(30)

3. Populate the CUSTOMER table with the data provided.

4. Create a VIEW named as MY_VIEW to display only rows that belong to the logged in user.

5. Grant SELECT and INSERT privilege on MY_VIEW to DBSEC_CLERK.

6. Connect to DBSEC_CLERK/.is481clerk You have created this user.

7. Insert one row of data into MY_VIEW as DBSEC_CLERK by using the following data. You may need to make corrections on the statement, but keep the data as they are.

INSERT INTO DBSEC.MY_VIEW ( SALES_REP_ID, CUSTOMER_ID, CUSTOMER_SSN, FIRST_NAME, LAST_NAME, ADDR_LINE,
CITY, STATE, ZIP_CODE, PHONE, EMAIL, CC_NUMBER, CREDIT_LIMIT, GENDER, STATUS,
COMMENTS, USER_NAME) VALUES (
7415, 901340, ''969996976'', ''Joe'', ''Cat'', ''993888 Moreno St.'', ''Champaign'', ''IL''
, '' 61801'', ''2173331613'', '''', ''2311468327372669'', 20000
, ''M'', ''A'', ''A fun loving student'', user);

8. Verify your data insertion by query MY_VIEW. You (as DBSEC_CLERK) should only see one row of data you have inserted. This signifies the success of your implementation.
Tips:

1. Your data insert statement will look similar to the following:
INSERT INTO CUSTOMER ( SALES_REP_ID, CUSTOMER_ID, CUSTOMER_SSN, FIRST_NAME, LAST_NAME, ADDR_LINE,
CITY, STATE, ZIP_CODE, PHONE, EMAIL, CC_NUMBER, CREDIT_LIMIT, GENDER, STATUS,
COMMENTS, USER_NAME) VALUES (
6415, 201340, ''969996970'', ''Jeffrey'', ''Antoine'', ''9938 Moreno St.'', ''Champagne'', ''SD''
, '' 43172'', ''4319071613'', '''', ''231146832737266'', 200000
, ''M'', ''A'', ''Any comments'', user);

2. Check on your login name at every step make sure your "connect" command line works as intended.

3. On step 7 above, why the view MY_VIEW needs to be prefixed with DBSEC?

4. On step 8 above, if you see more than one row of data, you may have logged in with incorrect user name. If you see no data, you need to check errors in the process as well.

Submission Requirement:
The SQL script files will be required as well as the screen capture of the creation.

Reference no: EM131482881

Questions Cloud

What is up current cost of equity : What is UP's current cost of equity? If the risk free rate is 7 percent and the market risk premium is 5 percent, what is UP's unlevered beta?

Eliminate traffic in the illicit goods : "If millions of people are desperate to buy and millions more desperate to sell, the trades will happen, whether we like it or not."

Draw a uml domain model class diagram for all systems : Draw a UML domain model class diagram for all systems in your chosen case study. Explain the role of use cases for the creation of a domain model of the problem

Warehouse move project : How will project communications and interactions work between the project manager, the stakeholders and the project team?

What are some of the private database cloud security issues : What are some of the private database cloud security issues and threats? How does this differ from the public database cloud environment?

Give an example of market failure : Academic studies suggest that the amount people tip at restaurants is only slightly related to the quality of service, and that tips are poor measures.

How to use the pmt function : The Excel PMT function is used to calculate the payment for a loan based on constant payments and a constant interest rate.

Business venture from assignment : Indicate the risk level associated with your business venture from Assignment 1. (Food Industry) Then

Why does it seem to be such contentious political issues : The U.S. Department of Labor reports that of the roughly 145 million people employed, just over half (73.9 million) are paid hourly, but less than 3%.

User Account

All Pages