Exasol
The following table shows the database specific support in DbVisualizer for Exasol organized per database 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 |
LUA 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 |
Preprocessors[3] | Preprocessors | |
Script | Export Script[2], Comment Script, Drop Script, Grant Privileges, Revoke Privileges | Script Editor[2], Grants, Script |
Virtual Schemas | Virtual Schemas | |
Virtual Schema | 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 |
Virtual Table | Export Table[2], Script: Script Table | Data, Columns, DDL[2], Info, Row Count |
Columns | Columns | |
Column | Comment Column | Column |
System Schemas | System Schemas | |
System Schema | ||
System Tables | Tables | |
System Table | Data | |
Columns | Columns | |
Column | Comment Column | Column |
DBA | Flush statistics | DBA |
Users | Create User LDAP[4], Create User[4] | Users |
User | Change LDAP Distinguished Name [4], Change Password, Comment User[4], Drop User[4], Grant Consumer Group to User, Grant Priority Group to User[5], Grant Role to User[4], Grant System Privilege to User[4], Rename User[4], Revoke Role from User[4], Revoke System Privilege From User[4] | Granted Connections, Granted Object Privileges, Granted Roles, Granted System Privileges, Info, Owned Schemas |
Roles | Create Role[4] | Roles |
Role | Comment Role[4], Drop Role[4], Grant Consumer Group to Role, Grant Priority Group to Role[5], Grant Role to Role[4], Grant System Privilege to Role[4], Rename Role[4], Revoke Role from Role[4], Revoke System Privilege From Role[4] | Granted Connections, Granted Object Privileges, Granted Roles, Granted System Privileges, Info, Owned Schemas |
User | Change LDAP Distinguished Name [4], Change Password, Comment User[4], Drop User[4], Grant Consumer Group to User, Grant Priority Group to User[5], Grant Role to User[4], Grant System Privilege to User[4], Rename User[4], Revoke Role from User[4], Revoke System Privilege From User[4] | Granted Connections, Granted Object Privileges, Granted Roles, Granted System Privileges, Info, Owned Schemas |
Consumer Groups[6] | Create Consumer Group[4] | Consumer Groups |
Consumer Group | Alter Consumer Group[4], Comment Consumer Group[4], Drop Consumer Group[4], Rename Consumer Group[4] | Info, Users and Roles |
Priority Groups | 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[7] | Connections |
Connection | Alter Connection[8], Comment Connection[7], Drop Connection[9], Grant Connection[10], Rename Connection[8], Revoke Connection[10] | Connection, Grantees |
Auditing[11] | Flush statistics | Audit Sessions last 24h, Audit by COMMAND_CLASS last week, Audit by USER_NAME/CLIENT last week, Recent Queries |
DB Size | 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 | |
Monitoring Last Hour | CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2] | |
Monitoring Hourly | CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2] | |
Monitoring Daily | CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2] | |
Monitoring Monthly | CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2] | |
SQL Statistics | ||
Statistics Hourly | 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] | |
Statistics Daily | 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] | |
Statistics Monthly | 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[4], Kill Statement in Session[4] | Audit Queries of Session[11], Info |
|
[1]
Version 6.1 and later and superuser
[2] DbVisualizer Pro [3] Version 2025年1月8日 and later [4] Must be superuser [5] Version 6 and earlier [6] Version 7 and later [7] Requires 'Create Connection' privilege [8] Requires 'Modify Connection' privilege [9] Requires 'Drop Connection' privilege [10] Requires 'Grant Connection' privilege [11] Requires 'Select Any Dictionary' privilege | ||