SYSCAT.TENANTAUTH catalog view

A view that contains all of the granted authorities to namespaces (tenants) not including the default SYSTEM tenant.

Table 1. SYSCAT.TENANT Catalog View
Column Name Data Type Nullable Description
ACCESSCTRLAUTH CHAR (1)   Tenant ACCESSCTRL authority to grant and revoke tenant object privileges.
  • N = Not held
  • Y = Held
ALTERINAUTH CHAR (1)   Privilege to alter or comment on objects in the named tenant.
  • G = Held and gran table
  • N = Not held
  • Y = Held
BINDADDAUTH CHAR (1)   Authority to create packages in the named tenant.
  • N = Not held
  • Y = Held
CREATEINAUTH CHAR (1)   Privilege to create objects in the named tenant.
  • G = Held and grantable
  • N = Not held
  • Y = Held
CREATETABAUTH CHAR (1)   Authority to create tables in the named tenant.
  • N = Not held
  • Y = Held
DATAACCESSAUTH CHAR (1)   Authority to access data.
  • N = Not held
  • Y = Held
DELETEINAUTH CHAR (1)  

Implicit DELETE privilege on all of the existing and future tables or updatable views defined in the tenant.

  • G = Held and grantable
  • N = Not held
  • Y = Held
DROPINAUTH CHAR (1)   Privilege to drop objects from the named tenant.
  • G = Held and grantable
  • N = Not held
  • Y = Held
EXECUTEINAUTH CHAR (1)  

Implicit EXECUTE privilege on all of the existing and future routines, packages and module objects defined in the tenant.

  • G = Held and grantable
  • N = Not held
  • Y = Held
EXPLAINAUTH CHAR (1)   Authority to explain SQL statements without requiring actual privileges on the objects in the statement.
GRANTEE VARCHAR (128)   Holder of a privilege.
GRANTEETYPE CHAR (1)  
  • G = Grantee is a group
  • R = Grantee is a role
  • U = Grantee is an individual user
GRANTOR VARCHAR (128)   Grantor of the authority.
GRANTORROLEID INTEGER   Identifier for the GRANTOR role.
GRANTORTYPE CHAR (1)  
  • S = Grantor is the system
  • U = Grantor is an individual user
GRANTORTYPE CHAR (1)  
  • S = Grantor is the system
  • U = Grantor is an individual user
GRANTEEROLEID INTEGER   Identifier for the GRANTEE role.
GRANTREVOKE_TIME TIMESTAMP   Time at which a privilege was last granted or revoked.
GRANT_TIME TIMESTAMP   Time at which a privilege was granted.
TENANTADMAUTH CHAR (1)   TENANTADM authority.
  • N = Not held
  • Y = Held
TENANTID INTEGETR   Identifier for the tenant
TENANTNAME VARCHAR (128)   Name of the tenant
UPDATEINAUTH CHAR (1)  

Implicit UPDATE privilege on all of the existing and future tables or updatable views defined in the tenant.

  • G = Held and grantable
  • N = Not held
  • Y = Held
USAGEAUTH CHAR (1)   Privilege to use the tenant and its components.
  • N = Not held
  • Y = Held