Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 398 Weeks Ago, 2 Days Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Computer Science Posted 14 Sep 2017 My Price 8.00

SQL scripts

Deliverables Include SQL scripts and screenshot of the results:

D1. Create the following three user-defined roles that are shown in the table below and assign them the specified permissions for the OE.CUSTOMERS table.

Role

Select

Insert

Update

Delete

account_managers

    

   X

  

customer_service

X

  

   X

  

sales_reps

X

X

   X

  

D2. Create user user1. Assign role account_manger to user1

D3. Use Oracle new connection to login as user1 and test permissions.

List all steps you performed to test permissions add screenshot with results

D4. Assign role sales_reps to user1

D5. As a part of an auditing process your company is conducting, you are required to report all users who have been granted system privileges with ADMIN option.
Write a query that will display users and their privileges. (Hint: use data dictionary SYS_PRIVS)

Include SQL scripts, number of rows and screenshot of the results

D6. Write SQL statement that lists all roles AND users (without repetition) who have access to the OE.CUSTOMERS table.

D7. How can you check that whether ACCOUNT_MANAGERS have permission to update only one column in CUSTOMERS table?

D8. Create an Oracle profile OE_PROFILE to limit database resources using the following criteria

a.   Logon timeA????12 hours

b.   Idle timeA????13 minutes

c.   CPU time required per callA????11 second

d.   1 block per query

D9. Assign profile OE_PROFILE to user1.

Answers

Maurice Tutor
(5)
Status NEW Posted 14 Sep 2017 07:09 PM My Price 8.00

Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll

Not Rated(0)
Relevent Questions