SYSCAT.TABAUTH catalog view

Each row represents a user, group, or role that has been granted one or more privileges on a table, view or nickname.

Table 1. SYSCAT.TABAUTH Catalog View
Column Name Data Type Nullable Description
GRANTOR VARCHAR (128)   Grantor of the privilege.
GRANTORTYPE CHAR (1)  
  • S = Grantor is the system
  • U = Grantor is an individual user
GRANTEE VARCHAR (128)   Holder of the privilege.
GRANTEETYPE CHAR (1)  
  • G = Grantee is a group
  • R = Grantee is a role
  • U = Grantee is an individual user
TABSCHEMA VARCHAR (128)   Schema name of the table or view.
TABNAME VARCHAR (128)   Unqualified name of the table or view.
CONTROLAUTH CHAR (1)   CONTROL privilege.
  • N = Not held
  • Y = Held but not grantable
ALTERAUTH CHAR (1)   Privilege to alter the table; allow a parent table to this table to drop its primary key or unique constraint; allow a table to become a materialized query table that references this table or view in the materialized query; or allow a table that references this table or view in its materialized query to no longer be a materialized query table.
  • G = Held and grantable
  • N = Not held
  • Y = Held
DELETEAUTH CHAR (1)   Privilege to delete rows from a table or updatable view.
  • G = Held and grantable
  • N = Not held
  • Y = Held
INDEXAUTH CHAR (1)   Privilege to create an index on a table.
  • G = Held and grantable
  • N = Not held
  • Y = Held
INSERTAUTH CHAR (1)   Privilege to insert rows into a table or updatable view, or to run the import utility against a table or view.
  • G = Held and grantable
  • N = Not held
  • Y = Held
REFAUTH CHAR (1)   Privilege to create and drop a foreign key referencing a table as the parent.
  • G = Held and grantable
  • N = Not held
  • Y = Held
SELECTAUTH CHAR (1)   Privilege to retrieve rows from a table or view, create views on a table, or to run the export utility against a table or view.
  • G = Held and grantable
  • N = Not held
  • Y = Held
UPDATEAUTH CHAR (1)   Privilege to run the UPDATE statement against a table or updatable view.
  • G = Held and grantable
  • N = Not held
  • Y = Held