The following actions are common database actions for which to grant permissions in identity policies:
Tabular Action | Description |
|---|---|
TabularCreateSchema | Create a schema in database. A schema is a container of tables |
TabularCreateTable | Create a table in database |
TabularAddColumns | Add columns to a table |
TabularAlterSchema | Rename or move a schema in the database |
TabularAlterTable | Rename or move a table between schemas |
TabularAlterColumn | Modify column name or properties |
TabularDropSchema | Drop a schema from the database |
TabularDropTable | Drop a table from the database |
TabularDropColumns | Drop a column from table |
TabularListSchemas | List a schemas below specified path |
TabularListTables | List tables below specified schema path |
TabularListColumns | List columns in a table |
TabularGetTableStats | Get table statistics which currently include number of rows and used bytes |
TabularBeginTransaction | Start a transaction |
TabularCommitTransaction | Commit a transaction |
TabularRollbackTransaction | Rollback a transaction |
TabularQueryData | SELECT like but returns pages of columns |
TabularInsertRows | Insert data to a table |
TabularImportData | Import data from parquet files (that were previously uploaded) to existing table |
TabularUpdateRows | Update rows in a table |
TabularDeleteRows | Delete rows from a table |
TabularGetTransaction | Check if transaction id exists and mark as in progress |
TabularCreateProjection | Create a projection table for existing table with sorted and unsorted keys from source table |
TabularDropProjection | Drop a projection table |
TabularAlterProjection | Rename or modify properties of a projection table |
TabularGetProjectionStats | Get projection table statistics, currently includes number of rows and used bytes |
TabularListProjections | List projections tables for a specified table |
TabularListProjectionColumns | List projection table columns |