Write a query that will display users and their privileges

Assignment Help Computer Engineering
Reference no: EM132135946

IN SQL DEVELOPER

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 theOE.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 time-2 hours

b.   Idle time-3 minutes

c.   CPU time required per call-1 second

d.   1 block per query

D9. Assign profile OE_PROFILE to user1.

Reference no: EM132135946

Questions Cloud

How many days long should your warranty be : You want to set the warranty length such that you only have to replace 1.5% of all the DVD players you sell. How many days long should your warranty be?
Write a program to predict the career totals for major : As usually described, the formula predicts the likelihood of the player achieving a particular goal, such as 500 home runs or 3000 hits.
Determine what the relationships should be among the classes : Add multiplicity constraints, being especially cognizant of zero-to-many versus one-to-many differences.
Calculate the point differential for each lineup : How many points does a particular lineup score vs how many do they give up to their opponents?
Write a query that will display users and their privileges : Create the following three user-defined roles that are shown in the table below and assign them the specified permissions.
What is the probability the salesman : Q. What is the probability the salesman will make exactly $50 in the next hour?
What can you do to identify duplicated data : What can you do to identify duplicated when the patient is being registered and after?
What is the probability that the student answers : If the student randomly guesses on each questions, what is the probability that the student answers fewer than 4 questions correctly?
Produce a report with descriptive report and column headings : Produce a report with descriptive report and column headings. Be sure there is enough data to prove the selection and sort worked as required.

Reviews

Write a Review

Computer Engineering Questions & Answers

  Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

  Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

  Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

  Realize business and organizational data storage

Realize business and organizational data storage and fast access times are much more important than they have ever been. Compare and contrast magnetic tapes, magnetic disks, optical discs

  What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

  Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

  Define open and closed loop control systems

Define open and closed loop cotrol systems.Explain difference between time varying and time invariant control system wth suitable example.

  Prepare a proposal to deploy windows server

Prepare a proposal to deploy Windows Server onto an existing network based on the provided scenario.

  Security policy document project

Analyze security requirements and develop a security policy

  Write a procedure that produces independent stack objects

Write a procedure (make-stack) that produces independent stack objects, using a message-passing style, e.g.

  Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

  Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices

Free Assignment Quote

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd