The user_name logs on. The resulting session has a label consisting of an unclassified level and a nato category. The first request executed for the session changes the label to a top_secret level and the category to a combination of united_states and nato.
SET SESSION CONSTRAINT = classification_level (top_secret), CONSTRAINT = classification_category (nato, united_states);
Assume that later on, the session initiated by user_name wanted to read one of the three rows from inventory, so the user submits the following SELECT request.
SELECT * FROM inventory WHERE col_1 = 1212;
The returned result set would be as follows.
Col_1 Col_2 Col_3 Classification_Level Classification_Category ===== ===== ===== ==================== ======================= 1212 90505 Widgets 3 '0100000000000000'XB