The dean decides use the faculty table support this effort
|
|
|
|
||||
---|---|---|---|---|---|---|---|
|
|
||||||
|
|
||||||
|
|
IT |
|
||||
|
|
|
|||||
|
|
OFFERINGNUM | |
---|---|
1111 | |
1233 | |
2222 |
|
3333 |
|
Grant the Student Role the privilege to ‘Select on Student’.
Grant the Faculty Role the privilege to ‘Select on Faculty’.
Grant UPDATE(address) on ‘S_Student’ to the Student Role.
Demonstrate how this works (this may be done with a before and after image of the student’s record with old and new student address).
Create a View that allows Juniors and Seniors the right to change their major (but does not allow anyone else to change their major).
Grant the necessary authority so that Juniors and Seniors can use this view.
Show the Dean executing a Select Name, Bonus from Faculty (if you know the column exists it can be accessed by explicitly using the name of the column in the Select statement).
Show how the Dean can update the bonus information (execute an Update giving every faculty member a 10% raise).
Show the Dean is still the only one who can update the bonus data. Show how to achieve this result. [Note: The solution is not a view with a Where clause of User = Name clause or a VPD].
The CISO is concerned that having both the ORGCD and TITLE in the same table reveals too much information--for example, Bond, ORGCD INT (Intelligence), TITLE SPY. Something must be done immediately to protect this information. As an interim step, TITLE should be completely redacted. Show how to achieve this result. (Use Full Redaction technique).
1234
2345
Mask the first 12 numbers with 9’s. The CC list will look like:
CC
9999999999994567
9999999999995678