Chat with us, powered by LiveChat Using your Oracle database, write SQL command to c - Writemia

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.

Do you need an answer to this or any other questions?

About Writemia

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Place Order” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order