Question: USING SQL plus I want to learn how to implement a table named clients using the CDB or PDB( I WANT screen shots from SQL

USING SQL plus I want to learn how to implement a table named clients using the CDB or PDB( I WANT screen shots from SQL plus being executed to learn how to do this)

Create a user account NLitzinger identified by the password Dubrucr90.

Solution: CREATE USER NLitzinger IDENTIFIED By DuBrucr90

b. Grant NLitzinger the SELECT and UPDATE permissions on the table called clients.

c. Create a user account HMimnaugh identified by the password EvCsvds01.

d. Grant HMimnaugh the SELECT and DELETE permissions on the table called clients.

e. Create a user account TylerM identified by the password Fwdtwet12.

f. Grant TylerM the SELECT and INSERT permissions on the table called clients.

g. Create a role named Most_Privileged without a password.

h. Grant the Most_Privileged role the Update and Delete permissions on the clients table.

i. Add all users to the Most_Privileged role.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!