03 Nov Using your Oracle database, write SQL command to c
Using your Oracle database, write SQL command to create the following tables and then answer each of the questions:Student(StudentId, StudentFName, StudentLName, Major, Credits)Faculty(FacultyId, FacultyName, Department, Rank)Class(ClassId, FacultyId, Timeslot, RoomNbr)Enroll(StudentId, ClassId, Grade)Create user BigBoss and give him permission to read and update the student class enrollments.Create user Tom201 and give him permission to read and update the student class enrollments, however, he should not have access to the student’s grade. How can you do that? (Hint: Create a new view and give the user access to this view)Allow everyone who works in the Dean’s Office to read student data. To do that:- Create a role named DeansOffice that has full read access to the Student table- Give this role to every user in the Dean’s office: you first need to create users for these people it is Bob202 and Alice303.Revoke the privileges of part a.