Assignment

General instructions: Consider that the set of attached SQL commands have already been run as a set up to this lab. You do not have to run them and should not run them (they are very complex to run). Your answers should be based on your understanding of the effect of those commands. The relevant material is in the database link session and the OLS sessions.

Assume that the role faculty was created and granted to Martin & Seaver and that Martin & Seaver users were created and granted create session.

1. 1) Data Links

a. Execute MICHAEL.UPDATE_HOURS(4); (by User Seaver)

b. Execute MICHAEL.UPDATE_SALARY(50000); (by User Seaver)

c. Execute MICHAEL.UPDATE_SALARY(70000); (by User Michael)

a. 2) 2: OLS Policy

1. What Student records does User Able see in response a Select *
2. What Student records does User Baker see in response to a Select
3. What Student records does User Charles see in response to a Select *

Attachment:- Lab-SQL.rar