Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Hands On Database

Authors: Steve Conger

1st Edition

013610827X, 978-0136108276

More Books

Students also viewed these Databases questions

Question

69 Needs assessment and analysis.

Answered: 1 week ago