User pls logs on. The resulting session has a label consisting of an unclassified level and a nato category. As soon as the session is established, pls changes the level to secret.
SET SESSION CONSTRAINT = classification_level (secret);
After the SET SESSION CONSTRAINT request executes, the session has a label of secret and nato.
Suppose that the session initiated by pls is used to insert 3 rows into the table named inventory. The INSERT requests used to insert the rows into inventory are as follows.
INSERT INTO inventory VALUES (1212, 90505,'Widgets',,); INSERT INTO inventory VALUES (12122, 90504,'Buggy Whips',,); INSERT INTO inventory VALUES (12126, 90501,'Whip Sockets',,);
The last two positional values are generated by the INSERT constraint UDFs, not by the session.
The column values for the rows after these INSERT requests complete are as follows.