Customer Testimonial:

I can't believe this software is available for free. It is a tool I use daily in software development of enterprise Java applications. A well ...

John Carl

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 Schemas
Schema
Export Schema1, Change owner of Schema, Comment Schema, Drop Schema, Grant Privileges, Rename Schema, Revoke Privileges Grants, Info
Tables
Create Table1, Import Table Data1 References, Tables
Table
Alter Table1, Export Table1, Import Table Data1, Comment Table, Distribute Table, Drop Distribution Key(s), Drop Table, Empty Table, Grant Privileges, Rename Table, Reorganize Table, Revoke Privileges, Script: Script Table Navigator1, References, Columns, Constraints, DDL, Data, Distribution, Distribution Keys, Grants, Indices, Info, Primary Key, Row Count, Size
Columns
  Columns
Column
  Column
Views
  Views
View
Drop View, Grant Privileges, Rename View, Revoke Privileges, Script: Script View Columns, DDL, Data, Dependencies, Grants, Info, Row Count
Columns
  Columns
Column
  Column
Functions
Create Function Functions
Function
Export Function, Comment Function, Drop Function, Grant Privileges, Rename Function, Revoke Privileges DDL, Grants, Info
Scripts
  Scripts
Adapters
  Adapters
AdaptersLUA
   
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, Grants, Script
AdaptersPython
   
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, Grants, Script
AdaptersR
   
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, Grants, Script
AdaptersJava
   
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, Grants, Script
AdaptersOther
   
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
UDFScalars
  Scalar
UDFScalarsLUA
  LUA
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, Grants, Script
UDFScalarsPython
  Python
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, Grants, Script
UDFScalarsR
  R
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, Grants, Script
UDFScalarsJava
  Java
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, Grants, Script
UDFScalarsOther
  Java
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, Grants, Script
UDFSets
  Set
UDFSetsLUA
   
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, Grants, Script
UDFSetsPython
   
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, Grants, Script
UDFSetsR
   
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, Grants, Script
UDFSetsJava
   
Script
Export Script, Comment Script, Grant Privileges, Revoke Privileges DDL, Grants, Script
UDFSetsOther
   
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 Table1, Import Table Data1 References, Tables
VirtualTable
  Columns, DDL, Data, Info, Row Count
Columns
  Columns
Column
  Column
SystemSchemas
  System Schemas
SystemSchema
   
SystemTables
  Tables
SystemTable
  Data
Columns
  Columns
Column
  Column
DBA
Flush statistics DBA
Users
Create User LDAP2, Create User2 Users
User
Change LDAP Distinguished Name 2, Change Password, Comment User2, Drop User2, Grant Priority to User2, Grant Role to User2, Grant System Privilege to User2, Rename User2, Revoke Role from User2, Revoke System Privilege From User2 Granted Connections, Granted Object Privileges, Granted Roles, Granted System Privileges, Info, Owned Schemas
Roles
Create Role2 Roles
Role
Comment Role2, Drop Role2, Grant Priority to Role2, Grant Role to Role2, Grant System Privilege to Role2, Rename Role2, Revoke Role from Role2, Revoke System Privilege From Role2 Granted Connections, Granted Object Privileges, Granted Roles, Granted System Privileges, Info, Owned Schemas
User
Change LDAP Distinguished Name 2, Change Password, Comment User2, Drop User2, Grant Priority to User2, Grant Role to User2, Grant System Privilege to User2, Rename User2, Revoke Role from User2, Revoke System Privilege From User2 Granted Connections, Granted Object Privileges, Granted Roles, Granted System Privileges, Info, Owned Schemas
Connections
Create Connection2 Connections
Connection
Alter Connection2, Comment Connection2, Drop Connection2, Grant Connection2, Rename Connection2, Revoke Connection2 Connection, Grantees
RecentQueries3
Flush statistics Audit Sessions last 24h, Audit by COMMAND_CLASS last week, Audit by USER_NAME/CLIENT last week
DatabaseSize
Flush statistics Database size daily, Database size hourly, Database size last day, Database size monthly
Usage
Flush statistics Usage daily, Usage hourly, Usage last day, Usage monthly
Monitoring
Flush statistics Monitoring daily, Monitoring hourly, Monitoring last day, Monitoring monthly
Statistics
  SQL Statistics daily, SQL Statistics hourly, SQL Statistics last day, SQL Statistics monthly
System
  General, Parameters, Storage Volumes, System Events
Locks
  Transaction conflicts
Sessions
  Sessions
Session
Kill Session2, Kill Statement in Session2 Audit Queries of Session3, Info
1) DbVisualizer Pro
2) Must be superuser
3)

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