Hands-On Project 6-1: Securing the Oracle Environment You have been hired as the

Question

Hands-On Project 6-1: Securing the Oracle Environment

You have been hired as the DBA for Haphazard, Inc. You are asked to fulfill the following needs of the Oracle Database environment.

1. Users, roles, and privileges need to be added to the database. Identify the statements that would be used for creating the following users, roles, and privileges that match the following requirements:

a. Create a user account NLitzinger identified by the password 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.

Explanation / Answer

Answer)

1. Users, roles, and privileges need to be added to the database. Identify the statements that would be used for creating the following users, roles, and privileges that match the following requirements:

a. Create a user account NLitzinger identified by the password Dubrucr90.

CREATE USER NLitzinger IDENTIFIED BY Dubrucr90;

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

GRANT SELECT, UPDATE ON clients TO NLitzinger;

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

CREATE USER HMimnaugh IDENTIFIED BY EvCsvds01;

d. Grant HMimnaugh the select and delete permissions on the table called clients.

GRANT SELECT, DELETE ON clients TO HMimnaugh;

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

CREATE USER TylerM IDENTIFIED BY Fwdtwet12;

f. Grant TylerM the select and insert permissions on the table called clients.

GRANT SELECT, INSERT ON clients TO TylerM;

g. Create a role named Most_Privileged without a password.

CREATE ROLE Most_Privileged;

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

GRANT UPDATE, DELETE ON clients TO Most_Privileged;

i. Add all users to the Most_Privileged role.

GRANT Most_Privileged to NLitzinger, HMimnaugh, TylerM;

/*Please Hit Like if you like my answer*/

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.