Create a security model as database security officer

For this example, log in as the newly created DSO and create a security model by using levels, categories, and cohorts.

SYSTEM.ADMIN(ADMIN)=> \c system dso dddd
You are now connected to database system as user dso.
SYSTEM.ADMIN(DSO)=> CREATE SECURITY LEVEL confidential VALUE 100;
CREATE SECURITY LEVEL
SYSTEM.ADMIN(DSO)=> CREATE SECURITY LEVEL secret VALUE 200;
CREATE SECURITY LEVEL
SYSTEM.ADMIN(DSO)=> CREATE SECURITY LEVEL "Top Secret" VALUE 300;
CREATE SECURITY LEVEL
SYSTEM.ADMIN(DSO)=> CREATE CATEGORY red;
CREATE CATEGORY
SYSTEM.ADMIN(DSO)=> CREATE CATEGORY green;
CREATE CATEGORY
SYSTEM.ADMIN(DSO)=> CREATE CATEGORY blue;
CREATE CATEGORY
SYSTEM.ADMIN(DSO)=> CREATE COHORT corp;
CREATE COHORT
SYSTEM.ADMIN(DSO)=> CREATE COHORT hr in COHORT corp;
CREATE COHORT
SYSTEM.ADMIN(DSO)=> CREATE COHORT fin in COHORT corp;
CREATE COHORT
SYSTEM.ADMIN(DSO)=> CREATE COHORT eng in COHORT corp;
CREATE COHORT
SYSTEM.ADMIN(DSO)=> CREATE COHORT qa in COHORT eng;
CREATE COHORT
SYSTEM.ADMIN(DSO)=> CREATE COHORT sw in COHORT eng;
CREATE COHORT
SYSTEM.ADMIN(DSO)=> CREATE COHORT hw in COHORT eng;
CREATE COHORT