Problem
Imagine that you are the database administrator for a military transportation system. You have a table named cargo in your database that contains information on the various cargo holds available on each outbound airplane. Each row in the table represents a single shipment and lists the contents of that shipment and the flight identification number. Only one shipment per hold is allowed. The flight identification number may be cross-referenced with other tables to determine the origin, destination, flight time, and similar data. The cargo table appears as follows:
|
Flight ID
|
Cargo Hold
|
Contents
|
Classification
|
|
1254
|
A
|
Boots
|
Unclassified
|
|
1254
|
B
|
Guns
|
Unclassified
|
|
1254
|
C
|
Atomic bomb
|
Top Secret
|
|
1254
|
D
|
Butter
|
Unclassified
|
Suppose that two roles are defined: Role 1 has full access rights to the cargo table. Role 2 has full access rights only to rows of the table in which the Classification field has the value Unclassified. Describe a scenario in which a user assigned to role 2 uses one or more queries to determine that there is a classified shipment on board the aircraft.