Exasol

Exasol object type support.

The following table shows the database specific support in DbVisualizer for Exasol organized per database object type.

  • Object Type - show what object types are listed in the Databases tab
  • Actions - show what actions are available for the object type
  • Viewers - show what viewers are available for the object type
Object Type Actions Viewers
Schemas
Create Schema Schema sizes, Schemas
Schema
Export Schema[2], Alter quota of Schema[1], Change owner of Schema, Comment Schema, Drop Schema, Grant Privileges, Rename Schema, Revoke Privileges Grants, Info, Schema size, Table Sizes
Tables
Create Table[2], Import Table Data[2] References, Tables
Table
Alter Table[2], Export Table[2], Import Table Data[2], Script: Script Table, Comment Table, Drop Table, Empty Table, Grant Privileges, Rename Table, Reorganize Table, Revoke Privileges Navigator[2], References, Data, Columns, Constraints, DDL[2], Distribution, Distribution Keys, Grants, Indices, Info, Primary Key, Row Count, Size
Columns
  Columns
Column
Comment Column Column
Constraints
  Constraints
Constraint
Enable/Disable Constraint Constraint Columns, Info
Views
  Views
View
Export View[2], Script: Script View, Drop View, Grant Privileges, Rename View, Revoke Privileges Data, Columns, DDL[2], Dependencies, Grants, Info, Row Count
Columns
  Columns
Column
Comment Column Column
Functions
Create Function Functions
Function
Export Function[2], Script: Script Function, Comment Function, Drop Function, Grant Privileges, Revoke Privileges Function Editor[2], Grants, Info
Scripts
  Scripts
Adapters
Create Adapter Adapters
Script
Export Script[2], Comment Script, Drop Script, Grant Privileges, Revoke Privileges Script Editor[2], Grants, Script
Scripting
Create Script LUA Scripting
Script
Export Script[2], Comment Script, Drop Script, Grant Privileges, Revoke Privileges Script Editor[2], Grants, Script
UDFs
Create UDF with EMIT, Create UDF with RETURN UDFs
Script
Export Script[2], Comment Script, Drop Script, Grant Privileges, Revoke Privileges Script Editor[2], Grants, Script
VirtualSchemas
  Virtual Schemas
VirtualSchema
Change owner of Virtual Schema, Comment Virtual Schema, Drop Virtual Schema, Grant Privileges, Refresh Virtual Schema, Rename Virtual Schema, Revoke Privileges DDL, Grants, Info, Properties
Tables
Create Table[2], Import Table Data[2] References, Tables
VirtualTable
Export Table[2], Script: Script Table Data, Columns, DDL[2], Info, Row Count
Columns
  Columns
Column
Comment Column Column
SystemSchemas
  System Schemas
SystemSchema
   
SystemTables
  Tables
SystemTable
  Data
Columns
  Columns
Column
Comment Column Column
DBA
Flush statistics DBA
Users
Create User LDAP[3], Create User[3] Users
User
Change LDAP Distinguished Name [3], Change Password, Comment User[3], Drop User[3], Grant Consumer Group to User, Grant Priority Group to User[4], Grant Role to User[3], Grant System Privilege to User[3], Rename User[3], Revoke Role from User[3], Revoke System Privilege From User[3] Granted Connections, Granted Object Privileges, Granted Roles, Granted System Privileges, Info, Owned Schemas
Roles
Create Role[3] Roles
Role
Comment Role[3], Drop Role[3], Grant Consumer Group to Role, Grant Priority Group to Role[4], Grant Role to Role[3], Grant System Privilege to Role[3], Rename Role[3], Revoke Role from Role[3], Revoke System Privilege From Role[3] Granted Connections, Granted Object Privileges, Granted Roles, Granted System Privileges, Info, Owned Schemas
User
Change LDAP Distinguished Name [3], Change Password, Comment User[3], Drop User[3], Grant Consumer Group to User, Grant Priority Group to User[4], Grant Role to User[3], Grant System Privilege to User[3], Rename User[3], Revoke Role from User[3], Revoke System Privilege From User[3] Granted Connections, Granted Object Privileges, Granted Roles, Granted System Privileges, Info, Owned Schemas
ConsumerGroups[5]
Create Consumer Group[3] Consumer Groups
ConsumerGroup
Alter Consumer Group[3], Comment Consumer Group[3], Drop Consumer Group[3], Rename Consumer Group[3] Info, Users and Roles
Priorities
Create Priority Group[1] Priorities
Priority
Alter Weight[1], Comment Priority Group[1], Drop Priority Group[1], Rename Priority Group[1] Info, Users and Roles
Connections
Create Connection[6] Connections
Connection
Alter Connection[7], Comment Connection[6], Drop Connection[8], Grant Connection[9], Rename Connection[7], Revoke Connection[9] Connection, Grantees
RecentQueries[10]
Flush statistics Audit Sessions last 24h, Audit by COMMAND_CLASS last week, Audit by USER_NAME/CLIENT last week, Recent Queries
DatabaseSize
Flush statistics Database size daily[2], Database size last day[2], Database size monthly[2]
Usage
Flush statistics Usage daily[2], Usage hourly[2], Usage last hour[2], Usage monthly[2]
Clusters
  Clusters
Cluster
   
Monitoring
Flush statistics  
MonitoringLastDay
  CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
MonitoringHourly
  CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
MonitoringDaily
  CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
MonitoringMonthly
  CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
Statistics
   
StatisticsHourly
  CPU AVG[2], CPU MAX[2], Count[2], Duration AVG[2], Duration MAX[2], HDD Read AVG[2], HDD Read MAX[2], HDD Write AVG[2], HDD Write MAX[2], Network AVG[2], Network MAX[2], Temp DB RAM Peak AVG[2], Temp DB RAM Peak MAX[2]
StatisticsDaily
  CPU AVG[2], CPU MAX[2], Count[2], Duration AVG[2], Duration MAX[2], HDD Read AVG[2], HDD Read MAX[2], HDD Write AVG[2], HDD Write MAX[2], Network AVG[2], Network MAX[2], Temp DB RAM Peak AVG[2], Temp DB RAM Peak MAX[2]
StatisticsMonthly
  CPU AVG[2], CPU MAX[2], Count[2], Duration AVG[2], Duration MAX[2], HDD Read AVG[2], HDD Read MAX[2], HDD Write AVG[2], HDD Write MAX[2], Network AVG[2], Network MAX[2], Temp DB RAM Peak AVG[2], Temp DB RAM Peak MAX[2]
System
  General, Parameters, Storage Volumes, System Events
Locks
  Transaction conflicts
Sessions
  Sessions
Session
Kill Session[3], Kill Statement in Session[3] Audit Queries of Session[10], Info
[1] Version 6.1 and later and superuser
[2] DbVisualizer Pro
[3] Must be superuser
[4] Version 6 and earlier
[5] Version 7 and later
[6] Requires 'Create Connection' privilege
[7] Requires 'Modify Connection' privilege
[8] Requires 'Drop Connection' privilege
[9] Requires 'Grant Connection' privilege
[10] Requires 'Select Any Dictionary' privilege
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗