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 17:00, smartoa

Annie is creating a corporate report for a company’s annual meeting. in the report, she wants to add the signature of various department heads. which device can annie use to capture signatures to include in the report? a. printer b. monitor c. e-reader d. digitizing tablet

Answers: 1

continue

Computers and Technology, 22.06.2019 18:30, lailahussain99

Which of the following is an example of intellectual properly! oa. new version of a novelb. journal of ideasc. pages of a bookood. lines of a poem

Answers: 2

continue

Computers and Technology, 22.06.2019 19:20, SundaeSunday

Consider the following code snippet: #ifndef cashregister_h#define cashregister_hconst double max_balance = 6000000.0; class cashregister{public: cashregister(); cashregister(double new_balance); void set_balance(double new_balance); double get_balance() const; private: double balance[12]; }; double get_monthly_balance(cashregister bk, int month); #endifwhich of the following is correct? a)the header file is correct as given. b)the definition of max_balance should be removed since header files should not contain constants. c)the definition of cashregister should be removed since header files should not contain class definitions. d)the body of the get_monthly_balance function should be added to the header file.

Answers: 1

continue

Computers and Technology, 22.06.2019 21:00, daniella0123

Simon says is a memory game where "simon" outputs a sequence of 10 characters (r, g, b, y) and the user must repeat the sequence. create a for loop that compares the two strings starting from index 0. for each match, add one point to userscore. upon a mismatch, exit the loop using a break statement. assume simonpattern and userpattern are always the same length. ex: the following patterns yield a userscore of 4: simonpattern: rrgbryybgy userpattern: rrgbbrybgy

Answers: 2

continue

You know the right answer?

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