Question: Assignment 3 ( 5 % Weightage ) 1 . As a DBA: I. CREATE TABLE WITH YOUR NAME II . III. ADD COLUMNS EMPLOYEE _
Assignment Weightage As a DBA: I. CREATE TABLE WITH YOUR NAME II III. ADD COLUMNS EMPLOYEEID FNAME, LNAME, SALARY INSERT ROWS IV Create users YOURNAMEct and YOURNAMEct V Make role called YOURNAMEdBwriter 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 YOURNAMEdBwriter role to YOURNAMEct and YOURNAMEct marks NOTE: ADD SCREENSHOTS OF COMMANDS AND ALSO A SCREENSHOT FROM SQLDEVELOPER TO SHOW ADDED USERS Explain several types of predefined roles in Oracle marks How externally authenticated users are different from Database authenticated users 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
