{{ curDB.name }} object type support

In DbVisualizer

The following table shows the database specific support in DbVisualizer Pro for {{ curDB.name }} 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, Revoke Privileges, Script: Script Function Function Editor, Grants, Info
Scripts
  Scripts
Adapters
Create Adapter Adapters
Script
Export Script, Comment Script, Drop Script, Grant Privileges, Revoke Privileges Script Editor, Grants, Script
Scripting
Create Script LUA Scripting
Script
Export Script, Comment Script, Drop Script, Grant Privileges, Revoke Privileges Script Editor, Grants, Script
UDFs
Create UDF with EMIT, Create UDF with RETURN UDFs
Script
Export Script, Comment Script, Drop Script, Grant Privileges, Revoke Privileges Script Editor, 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 Consumer Group to User, Grant Priority Group to User4, 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 Consumer Group to Role, Grant Priority Group to Role4, 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 Consumer Group to User, Grant Priority Group to User4, 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
ConsumerGroups5
Create Consumer Group3 Consumer Groups
ConsumerGroup
Alter Consumer Group3, Comment Consumer Group3, Drop Consumer Group3, Rename Consumer Group3 Info, Users and Roles
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
RecentQueries6
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 Session6, 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) Any Dictionary