SYSCAT.TBSPACEAUTH catalog view

Each row represents a user, group, or role that has been granted the USE privilege on a particular table space in the database.

Table 1. SYSCAT.TBSPACEAUTH 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
TBSPACE VARCHAR (128)   Name of the table space.
USEAUTH CHAR (1)   Privilege to create tables within the table space.
  • G = Held and grantable
  • N = Not held
  • Y = Held