Object Type |
Actions |
Viewers |
|
|
Catalogs
|
|
Create Database
|
Catalogs
|
|
|
Catalog
|
|
Drop Database, Rename Database
|
References, Tables
|
|
|
Schemas
|
|
Create Schema
|
Schemas
|
|
|
Schema
|
|
Export Schema[1], Drop Schema, Rename Schema
|
Info
|
|
|
Tables
|
|
Create Table[1], Import Table Data[1]
|
References, Tables
|
|
|
Table
|
|
Alter Table[1], Export Table[1], Import Table Data[1], Script: Script Table, Drop Table, Empty Table, Rename Table
|
Navigator[1], References, Data, Columns, DDL[1], Grants, Info, Primary Key, Row Count
|
|
|
Columns
|
|
|
Columns
|
|
|
Column
|
|
|
Column
|
|
|
Views
|
|
|
Views
|
|
|
View
|
|
Export View[1], Script: Script View, Drop View, Rename View
|
Columns, DDL[1], Data, Info, Row Count
|
|
|
Columns
|
|
|
Columns
|
|
|
Column
|
|
|
Column
|
|
|
Sequences
|
|
Create Sequence
|
Sequences
|
|
|
Sequence
|
|
Drop Sequence, Rename Sequence
|
Info
|
|
|
Procedures
|
|
Create Procedure
|
Procedures
|
|
|
Procedure
|
|
Export Procedure[1], Script: Script Procedure, Comment Procedure, Drop Procedure, Rename Procedure
|
Procedure Editor[1], Interface
|
|
|
Functions
|
|
Create Function
|
Functions
|
|
|
Function
|
|
Export Function[1], Script: Script Function, Comment Function, Drop Function, Rename Function
|
Function Editor[1], Interface
|
|
|
ExternalTables
|
|
|
External Tables
|
|
|
ExternalTable
|
|
|
External Tables
|
|
|
MaterializedViews
|
|
|
Materialized Views
|
|
|
MaterializedView
|
|
Script: Script Materialized View, Drop Materialized View
|
Data, Columns, Info, Row Count
|
|
|
FileFormats
|
|
|
FileFormats
|
|
|
FileFormat
|
|
|
FileFormat
|
|
|
Stages
|
|
|
Stages
|
|
|
Stage
|
|
|
Stage
|
|
|
Pipes
|
|
|
Pipes
|
|
|
Pipe
|
|
|
Pipe
|
|
|
DBA
|
|
|
DBA
|
|
|
ServerInfo
|
|
|
Parameters
|
|
|
Users
|
|
Create User[2]
|
Users, Users[2]
|
|
|
User[2]
|
|
Abort all queries, Disable/Enable User, Drop User, Rename User
|
Describe, Info, Last Queries, Login Attempts
|
|
|
Roles
|
|
Create Role[2]
|
Enabled Roles, Roles
|
|
|
Role
|
|
Drop Role[2]
|
Info, Role grants
|
|
|
Warehouses
|
|
Create Warehouse
|
Metering history 10 days, Warehouses
|
|
|
Warehouse
|
|
Drop Warehouse, Resume/Suspend
|
Info
|
|
|
Locks
|
|
|
Locks
|
|
|
QueryHistory
|
|
|
Last Queries
|
[1]
DbVisualizer Pro
[2]
Requires the SECURITY_ADMIN role
|