Information Schema

LakeCLI provides two tables:

  1. database_privileges
  2. table_privileges

Database Privileges

ColumnDescription
idPrimary Key
schema_nameName of the Schema
principalAWS IAM Role or User
permissionPermission type (Described in a later section)
grantBoolean. Describes if the principal is allowed to grant permission to others

Table Privileges

ColumnDescription
idPrimary Key
schema_nameSchema Name of the Table
table_nameName of the Table
principalAWS IAM Role or User
permissionPermission type (Described in a later section)
grantBoolean. Describes if the principal is allowed to grant permission to others

GRANT/REVOKE Statements

GRANT/REVOKE { { PERMISSION TYPE }
[, ...] }
ON { [ TABLE | DATABASE ] name }
TO role_specification

Permission Types

  • ALL
  • SELECT
  • ALTER
  • DROP
  • DELETE
  • INSERT
  • CREATE_DATABASE
  • CREATE_TABLE
  • DATA_LOCATION_ACCESS