Object Type |
Actions |
Viewers |
|
Create Schema
|
Schema sizes, Schemas
|
|
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
|
|
Create Table[2], Import Table Data[2]
|
References, Tables
|
|
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
|
|
Comment Column
|
Column
|
|
|
Constraints
|
|
Enable/Disable Constraint
|
Constraint Columns, Info
|
|
|
Views
|
|
Export View[2], Script: Script View, Drop View, Grant Privileges, Rename View, Revoke Privileges
|
Data, Columns, DDL[2], Dependencies, Grants, Info, Row Count
|
|
|
Columns
|
|
Comment Column
|
Column
|
|
Create Function
|
Functions
|
|
Export Function[2], Script: Script Function, Comment Function, Drop Function, Grant Privileges, Revoke Privileges
|
Function Editor[2], Grants, Info
|
|
|
Scripts
|
|
Create Adapter
|
Adapters
|
|
Export Script[2], Comment Script, Drop Script, Grant Privileges, Revoke Privileges
|
Script Editor[2], Grants, Script
|
|
Create Script
|
LUA Scripting
|
|
Export Script[2], Comment Script, Drop Script, Grant Privileges, Revoke Privileges
|
Script Editor[2], Grants, Script
|
|
Create UDF with EMIT, Create UDF with RETURN
|
UDFs
|
|
Export Script[2], Comment Script, Drop Script, Grant Privileges, Revoke Privileges
|
Script Editor[2], Grants, Script
|
|
|
Virtual Schemas
|
|
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
|
|
Create Table[2], Import Table Data[2]
|
References, Tables
|
|
Export Table[2], Script: Script Table
|
Data, Columns, DDL[2], Info, Row Count
|
|
|
Columns
|
|
Comment Column
|
Column
|
|
|
System Schemas
|
|
|
|
|
|
Tables
|
|
|
Data
|
|
|
Columns
|
|
Comment Column
|
Column
|
|
Flush statistics
|
DBA
|
|
Create User LDAP[3], Create User[3]
|
Users
|
|
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
|
|
Create Role[3]
|
Roles
|
|
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
|
|
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
|
|
Create Consumer Group[3]
|
Consumer Groups
|
|
Alter Consumer Group[3], Comment Consumer Group[3], Drop Consumer Group[3], Rename Consumer Group[3]
|
Info, Users and Roles
|
|
Create Priority Group[1]
|
Priorities
|
|
Alter Weight[1], Comment Priority Group[1], Drop Priority Group[1], Rename Priority Group[1]
|
Info, Users and Roles
|
|
Create Connection[6]
|
Connections
|
|
Alter Connection[7], Comment Connection[6], Drop Connection[8], Grant Connection[9], Rename Connection[7], Revoke Connection[9]
|
Connection, Grantees
|
|
Flush statistics
|
Audit Sessions last 24h, Audit by COMMAND_CLASS last week, Audit by USER_NAME/CLIENT last week, Recent Queries
|
|
Flush statistics
|
Database size daily[2], Database size last day[2], Database size monthly[2]
|
|
Flush statistics
|
Usage daily[2], Usage hourly[2], Usage last hour[2], Usage monthly[2]
|
|
|
Clusters
|
|
|
|
|
Flush statistics
|
|
|
|
CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
|
|
|
CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
|
|
|
CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
|
|
|
CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
|
|
|
|
|
|
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]
|
|
|
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]
|
|
|
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]
|
|
|
General, Parameters, Storage Volumes, System Events
|
|
|
Transaction conflicts
|
|
|
Sessions
|
|
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
|