Question: Create three new users with names and privileges as described below in Oracle database: Show the code you used to make these users and

Create three new users with names and privileges as described below in Oracle database:


Name User1 User2 User3 Privileges select, insert, update, and delete for the

 



Show the code you used to make these users and grant them the correct privileges.

Name User1 User2 User3 Privileges select, insert, update, and delete for the department table only select, insert, and update for the department and faculty tables only select, insert, update, and delete for the department table, faculty table, and prof_class_size view only

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!