Permissions Tables

This section contains the reference documentation for the Splice Machine SQL System Tables containing information about permissions.

Since the system tables belong to the SYS schema, you must preface any inquiries involving these tables with the SYS. prefix.

The Permissions System Tables are:

System Table Description
SYSCOLPERMS Stores the column permissions that have been granted but not revoked.
SYSPERMS Describes the usage permissions for sequence generators and user-defined types.
SYSROUTINEPERMS Stores the permissions that have been granted to routines.
SYSTABLEPERMS Stores the table permissions that have been granted but not revoked.