Question: Assignment 3 ( 5 % Weightage ) 1 . As a DBA: I. CREATE TABLE WITH YOUR NAME II . III. ADD COLUMNS EMPLOYEE _

Assignment 3(5% Weightage)1. As a DBA: I. CREATE TABLE WITH YOUR NAME II. III. ADD COLUMNS EMPLOYEE_ID, FNAME, LNAME, SALARY INSERT 2-3 ROWS IV. Create 2 users YOURNAME_ct1 and YOURNAME_ct2 V. Make role called YOURNAME_dBwriter with the below privileges Can create sessions, create tables, and create views. Can update, and insert rows into created table Can select from created table Assign YOURNAME_dBwriter role to YOURNAME_ct1 and YOURNAME_ct2(10 marks) NOTE: ADD SCREENSHOTS OF COMMANDS AND ALSO A SCREENSHOT FROM SQLDEVELOPER TO SHOW ADDED USERS 2. Explain several types of predefined roles in Oracle (5 marks)3. How externally authenticated users are different from Database authenticated users (5 marks) NOTE: FOR THIS ASSIGNMENT USE THE CONNECTION INFO GIVEN IN THE PROJECT DESCRIPTION

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 Programming Questions!