Write sql statement that lists all roles and users

Assignment Help Database Management System

Reference no: EM132135956

In SQL Developer ONLY!

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 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: EM132135956

Questions Cloud

What are the advantages and disadvantages of standards : What are the advantages and disadvantages of standards? How do standards fit in with regulations at the federal, manufacturing, and organizational levels?

What is the probability that the student has a paid : A student is chosen at random from this sample. What is the probability that the student has a paid assistant-ships?

Perform the test for the non-additive join property : Perform the test for the non-additive join property (lossless join) for the relation R.

Outcomes of hospital care different on weekends : Are the outcomes of hospital care different on weekends than weekdays? In a random sample of 500 patients who experienced severe medical complications

Write sql statement that lists all roles and users : How can you check that whether ACCOUNT_MANAGERS have permission to update only one column in CUSTOMERS table?

Compute the probability of randomly selecting a three or ten : A standard deck of cards contains 52 cards. (a) Compute the probability of randomly selecting a three or ten. (b) Compute the probability of randomly selectin

Tens of thousands of retail outlets : You work for a large company with tens of thousands of retail outlets throughout the world. The average sales at each retail outlet is $2,400,000 per year

Real world example of a unfavorable result : A real world example of a unfavorable result in an experiment and what could have been done to avoid the outcome of the experiment?

Explain the two sql functions and the importance of function : Explain the two SQL functions and the importance of each function. Please include when these functions might be used.

User Account

All Pages