Customer Testimonial:

Subject: DbVisualizer is fantastic
I am writing to tell you I've just downloaded DbVisualizer and I think it's excellent. I have spent 4...

Ben Hutchison

Exasol

Database Specific Support

The following table show the database specific support 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 Schema2, Alter quota of Schema1, Change owner of Schema, Comment Schema, Drop Schema, Grant Privileges, Rename Schema, Revoke Privileges Grants, Info, Schema size, Table Sizes
Tables
Create Table2, Import Table Data2 References, Tables
Table
Alter Table2, Export Table2, Import Table Data2, Comment Table, Drop Table, Empty Table, Grant Privileges, Rename Table, Reorganize Table, Revoke Privileges, Script: Script Table Navigator2, References, Data, Columns, Constraints, DDL, 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, Drop View, Grant Privileges, Rename View, Revoke Privileges, Script: Script View Data, Columns, DDL, Dependencies, Grants, Info, Row Count
Columns
  Columns
Column
Comment Column Column
Functions
Create Function Functions
Function
Export Function, Comment Function, Drop Function, Grant Privileges, Rename Function, Revoke Privileges, Script: Script Function DDL, Grants, Info
Scripts
  Scripts
Adapters
  Adapters
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, Grants, Script
Scripting
  LUA Scripting
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, Grants, Script
UDFs
  UDFs
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, 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 Table2, Import Table Data2 References, Tables
VirtualTable
Export Table2, Script: Script Table Data, Columns, DDL, 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 LDAP3, Create User3 Users
User
Change LDAP Distinguished Name 3, Change Password, Comment User3, Drop User3, Grant Priority Group to User3, Grant Role to User3, Grant System Privilege to User3, Rename User3, Revoke Role from User3, Revoke System Privilege From User3 Granted Connections, Granted Object Privileges, Granted Roles, Granted System Privileges, Info, Owned Schemas
Roles
Create Role3 Roles
Role
Comment Role3, Drop Role3, Grant Priority Group to Role3, Grant Role to Role3, Grant System Privilege to Role3, Rename Role3, Revoke Role from Role3, Revoke System Privilege From Role3 Granted Connections, Granted Object Privileges, Granted Roles, Granted System Privileges, Info, Owned Schemas
User
Change LDAP Distinguished Name 3, Change Password, Comment User3, Drop User3, Grant Priority Group to User3, Grant Role to User3, Grant System Privilege to User3, Rename User3, Revoke Role from User3, Revoke System Privilege From User3 Granted Connections, Granted Object Privileges, Granted Roles, Granted System Privileges, Info, Owned Schemas
Priorities
Create Priority Group1 Priorities
Priority
Alter Weight1, Comment Priority Group1, Drop Priority Group1, Rename Priority Group1 Info, Users and Roles
Connections
Create Connection3 Connections
Connection
Alter Connection3, Comment Connection3, Drop Connection3, Grant Connection3, Rename Connection3, Revoke Connection3 Connection, Grantees
RecentQueries4
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, Database size last day, Database size monthly
Usage
Flush statistics Usage daily, Usage hourly, Usage last hour, Usage monthly
Monitoring
Flush statistics  
MonitoringLastDay
  CPU / Load, HDD / Network / SWAP, Temp DB RAM [MiB]
MonitoringHourly
  CPU / Load, HDD / Network / SWAP, Temp DB RAM [MiB]
MonitoringDaily
  CPU / Load, HDD / Network / SWAP, Temp DB RAM [MiB]
MonitoringMonthly
  CPU / Load, HDD / Network / SWAP, Temp DB RAM [MiB]
Statistics
   
StatisticsHourly
  CPU AVG, CPU MAX, Count, Duration AVG, Duration MAX, HDD Read AVG, HDD Read MAX, HDD Write AVG, HDD Write MAX, Network AVG, Network MAX, Temp DB RAM Peak AVG, Temp DB RAM Peak MAX
StatisticsDaily
  CPU AVG, CPU MAX, Count, Duration AVG, Duration MAX, HDD Read AVG, HDD Read MAX, HDD Write AVG, HDD Write MAX, Network AVG, Network MAX, Temp DB RAM Peak AVG, Temp DB RAM Peak MAX
StatisticsMonthly
  CPU AVG, CPU MAX, Count, Duration AVG, Duration MAX, HDD Read AVG, HDD Read MAX, HDD Write AVG, HDD Write MAX, Network AVG, Network MAX, Temp DB RAM Peak AVG, Temp DB RAM Peak MAX
System
  General, Parameters, Storage Volumes, System Events
Locks
  Transaction conflicts
Sessions
  Sessions
Session
Kill Session3, Kill Statement in Session3 Audit Queries of Session4, Info
1) Version 6.1 and later and superuser
2) DbVisualizer Pro
3) Must be superuser
4) Any Dictionary

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.

Close