SYSSECPOLICYEXEMPTIONS

The syssecpolicyexemptions system catalog table records the exemptions that have been given to users. It has these columns.
Column Type Explanation
grantee CHAR(32) The user who has this exemption
secpolicyid INTEGER ID of the policy on which the exemption is granted
exemption CHAR(6) The exemption given to the user who is identified in the GRANTEE column. The six characters have the following meanings:
  • 1 = Read array
  • 2 = Read set
  • 3 = Read tree
  • 4 = Write array
  • 5 = Write set
  • 6 = Write tree

Each character has one of the following values:

  • E = Exempt
  • D = Write down exemption
  • U = Write up exemption
  • – = No exemption