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
Get step-by-step solutions from verified subject matter experts
