Computers and Technology, 22.04.2020 03:47, PaulJames

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)

a. Create user BigBoss and give him permission to read and update the student class enrollments.

b. 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)

c. 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.

d. Revoke the privileges of part a.

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 20:40, wutdmgamerz

Assume that there is a 4% rate of disk drive failure in a year. a. if all your computer data is stored on a hard disk drive with a copy stored on a second hard disk drive, what is the probability that during a year, you can avoid catastrophe with at least one working drive? b. if copies of all your computer data are stored on three independent hard disk drives, what is the probability that during a year, you can avoid catastrophe with at least one working drive?

Answers: 1

continue

Computers and Technology, 22.06.2019 21:30, mjweed2456

Nathan wants to create multiple worksheet containing common formatting styles for his team members. which file extension him to save these worksheets? nathan to create multiple worksheets with common styles. he needs to save them with the extension.

Answers: 1

continue

Computers and Technology, 23.06.2019 00:00, destinysmithds7790

Suppose you have 9 coins and one of them is heavier than others. other 8 coins weight equally. you are also given a balance. develop and algorithm to determine the heavy coin using only two measurements with the of the balance. clearly write your algorithm in the form of a pseudocode using the similar notation that we have used in the class to represent sorting algorithms

Answers: 1

continue

Computers and Technology, 23.06.2019 14:00, uday50

Select the correct answer. a company is currently focusing on creating specific management goals for itself. which level of maturity is the company demonstrating under the sse_ccm framework? a. performed informally b. planned and tracked c. quantitatively controlled d. well-defined e. continuously improving

Answers: 2

continue

Do you know the correct answer?

Using your Oracle database, write SQL command to create the following tables and then answer each of...