Database Support

List Displays

• List of Tables/Views etc including Description

• List of Tables with Table Sizing

• List of Tables/Views etc with Create / Alter date

• List of Tables with Reorg Pending flag

• List of MDC tables, partitioned tables, column-organized tables

Details Display

• Columns

• Column sizing

• Table Details

• Primary Key Columns

• Unique Constraint Columns

• Indexes and Index Sizing

• Authorities on Table

• Views on Table

• Aliases on Table

• Packages using Table

• Compiled Routines using Table

• Other objects using Table

• Triggers on/using Table

• Referenced Tables (Foreign Keys)

• Dependent Tables

• Hash Partitioning Key

• Range Partitions and Partitioning Expressions

• MDC Dimensions

• Create / Alter / Drop / Redefine Table

• Create View / Summary Table on table

• Create Primary Key / Index / Unique Constraint on Table

• Create Foreign Key on Table

• Create Trigger on Table

• Create Check Constraint on Table

• Create Alias on Table

• Generate DDL for Table and related indexes, keys, views, triggers, constraints, aliases

• Administer Authorities for Table

• Compare tables definitions

• Manage table descriptions

• Manage column descriptions

• Rename table/s

• Rename columns

• Reset check pending on table/s

• Set integrity off for Tables

• Runstats on Table/s

• Reorg Table/s

• Activate not logged

• Delete contents of Table/s (truncate)

• Rebind dependent packages for Table

• Columns

• View Details

• View Definition

• Authorities on View

• Views on View

• Aliases on View

• Packages using View

• Routines using View

• Triggers on View

• Other objects using View

• Objects used by View

• Create / Alter / Drop View

• Generate DDL for View

• Administer Authorities for View

• Compare View definitions

• Manage View comments

• Manage column comments

• Columns

• Alias Details

• Authorities on Alias

• Views on Alias

• Aliases on Alias

• Packages using Alias

• Other objects using Alias

• Create / Alter / Drop Alias

• Generate DDL for Alias

• Columns

• Column sizing

• Summary Table Definition

• Table Details

• Indexes and Index Sizing

• Authorities on View

• Views on Table

• Aliases on Table

• Packages using Table

• Compiled Routines using Table

• Other objects using Table

• Hash Partitioning Key

• Range Partitions and Partitioning Expressions

• MDC Dimensions

• Create / Drop Summary Table

• Create View / Alias / Index on Summary Table

• Generate DDL for Table and related indexes, views, aliases

• Administer Authorities for Summary Table

• Manage table descriptions

• Manage column descriptions

• Rename Summary Table/s

• Rename columns

• Runstats on table/s

• Reorg table/s

• Refresh Summary Table

• Set Definition Only

• Activate not logged

• Columns

• Nickname Options

• Nickname Column Mappings

• Nickname Details

• Authorities on Nickname

• Packages using Nickname

• Create / Drop Nickname

• Generate DDL for Nickname

• Administer Authorities for Nickname

• Manage Nickname descriptions

List Displays

• List of Indexes with Index Type and indexed Table

• List of Indexes with Index Sizing

• List of Indexes with Last Used Date

• List of Indexes with Descriptions

Details Displays

• Index Columns

• Index Details

• Authorities on Index

• Dependent Packages

• Create / Drop Index

• Generate DDL for Index

• Administer Authorities for Index

• Manage Index descriptions

• Rename Index

• Runstats on Index

List Displays

• List of Tablespaces with Tablespace Type and Description

• List of Tablespaces with physical details (page size, bufferpool, partition group, storage group)

• List of Tablespaces with Sizing Info

• List of Tablespaces with Snapshot Info (current sizing)

Details Displays

• Tables in Tablespace

• Range Partitions in Tablespace

• Indexes in Tablespace

• Authorities on Tablespace

• Tablespace Containers

• Tablespace Utilization

• Tablespace Snapshot detail

• Create / Alter Tablespace

• Generate DDL for Tablespace including tables in Tablespace

• Administer Authorities for Tablespace

• Compare Tablespaces

• Rename Tablespace

• Set Tablespace/s online

• Extend Containers

• Package Detail

• Objects used by Package

• Routines used by Package

• Package Statements

• Authorities for Package

• Drop Package

• Rebind Package/s

• Explain Package/s

• Administer Authorities for Package

• Trigger Text

• Trigger Detail

• Objects used by Trigger

• Create / Alter / Drop Trigger

• Generate DDL for Trigger

• Compare Trigger

• Manage Trigger descriptions

• Routine Parameters

• Routine Text

• Routine Detail

• Object used by Routine

• Views using Routine

• Packages using Routine

• Routines using Routine

• Authorities for Routine

• Create SQL or External Routine

• Alter / Drop Routine

• Generate DDL for Routine

• Compare Routine

• Manage Routine descriptions

• Routines in Module

• Module Text

• Module Detail

• Module Parameters

• Modules Variables

• Objects used by Module

• Routines using Module

• External Routines detail

• Tables in Bufferpool

• Indexes in Bufferpool

• Create / Alter / Drop Bufferpool

• Generate DDL for Bufferpool

• Partitions in Partition Group

• Tablespaces in Partition Group

• Partition-Group specific Bufferpools

• Generate DDL for Partition Group

• Details of Storage Group

• Tablespaces using Storage Group

• Sizing of Tablespaces using Storage Group

• Details of Sequence

• Tables using Sequence

• Authorities for Sequence

• Create / Alter / Drop Sequence

• Generate DDL for Sequence

• Compare Sequences

• Manage Authorities for Sequence

• Roles for User / Group

• Authids with have this Role

• Table Authorities

• Table Authorities (with Grantor)

• Package Authorities

• Schema Authorities

• Tablespace Authorities

• Database Authorities

• Index Authorities

• Function Authorities

• Procedure Authorities

• Sequence Authorities

• Create / Alter Role

• Manage Role Membership

• Manage Table Authorities

• Manage Package Authorities

• Manage Schema Authorities

• Manage Tablespace Authorities

• Manage Database Authorities

• Manage Index Authorities

• Manage Function Authorities

• Manage Procedure Authorities

• Manage Sequence Authorities

• System and User Data Types

• Servers with Nicknames and Type Mappings

• Column Name

• XSR Objects

• Security Labels

List Displays

• List of Tables/Views etc including Description

• List of Tables with Table Sizing

• List of Tables/Views etc with Create / Alter date

• List of Clones Tables

• List of Tables with their Archived Tables

Details Display

• Columns

• Identity columns

• Primary Key Columns

• Indexes

• Tablespace partitions

• Check Constraints

• Authorities on Table

• Packages using Table

• Views on Table

• Local Aliases on Table

• Synonyms on Table

• Triggers on Table

• Referenced Tables (Foreign Keys)

• Dependent Tables

• Auxiliary Tables

• Create / Alter / Drop / Redefine Table

• Create View on table

• Create Alias on Table

• Create Primary Key / Index / Unique Constraint on Table

• Create Foreign Key on Table

• Create Trigger on Table

• Create Check Constraint on Table

• Create Remote Alias on Table

• Create Auxiliary Table

• Create Partitioning Index

• Generate DDL for Table and related indexes, keys, views, triggers, constraints, aliases

• Administer Authorities for Table

• Compare table definitions

• Manage table comments

• Manage table labels

• Manage column comments

• Manage column labels

• Rename table/s

• Rename columns

• Columns

• View Details

• View Definition

• Authorities on View

• Dependent Packages

• Views on View

• Local Aliases on View

• Synonyms on View

• Objects used by View

• Triggers on View

• Create / Alter / Drop View

• Create Trigger on View

• Generate DDL for View

• Administer Authorities for View

• Compare View definitions

• Manage view comments

• Manage view labels

• Manage view comments

• Manage view labels

• Columns

• Base table/view (local aliases only)

• Alias Detail

• Dependent Packages

• Create / Drop Alias

• Create remote Alias

• Generate DDL for Alias

• Manage Alias comments

• Columns

• Base table/view

• Dependent Packages

• Create / Drop Synonym

• Generate DDL for Synonym

• Columns

• Indexes

• Tablespace Partitions

• Full Detail

• Access List

• Dependent Packages

• Views on MQT

• Local Aliases on MQT

• Synonyms on MQT

• MQT Definition

• Create / Alter / Drop MQT

• Generate DDL for MQT

• Administer Authorities for MQT

• Refresh MQT

• Manage MQT comments

• Manage MQT labels

• Manage MQT comments

• Manage MQT labels

• Base table

• Columns

• Full Detail

• Indexes

• Create Auxiliary Table

• Generate DDL for Aux Table

• Manage Table comments

• Manage Table labels

• Columns in Index

• Column Expressions

• Index Details

• Index Partitions

• Packages using Index

• Create / Alter / Drop Index

• Generate DDL for Index

• Manage Index comments

List of Tablespaces within Database

• Tablespaces with Sizing

• Tablespaces with Status

• Tablespaces with Physical Info

• Tablespaces with Tablespace Ids

• Tablespaces with Other Details

• Tablespaces with Last Image Copy

Tablespace Details

• Tables within Tablespace

• Table sizing info

• Tablespace Details

• Tablespace Partitions

• Image Copies of Tablespace

• Create / Alter / Drop Tablespace

• Create standard or partitioned Tablespace

• Generate DDL for Tablespace

• Compare Tablespaces

• Plan Detail

• Packages in Plan

• Objects used by Plan

• Statements

• Authorities on Plan

• Administer Authorities for Plan

• Compare Plans

• Package Detail

• Objects used by Package

• Statements

• Authorities on Package

• Authorities on related Procedure / Function

• Drop Package

• Generate Bind Package statement

• Administer Authorities for Package

• Compare Packages

• Trigger Detail

• Trigger Text

• Create / Redefine / Drop Trigger

• Generate DDL for Trigger

• Compare Triggers

• Manager Trigger comments

• Routine Parms

• Routine Detail

• Routine Text (SQL Routine only)

• User Authorities on Routine

• Package Authorities on Routine

• Create / Alter / Redefine / Drop Routine

• Create External or SQL Routine

• Generate DDL for Routine

• Manage Routine comments

• Manage authorities on Routine

• Alter Procedure Options

• Drop Procedure Version

• Activate Procedure Version

• Table Authorities

• Plan Authorities

• Package Authorities

• Database Authorities

• Procedure Authorities

• Function Authorities

• Sequence Authorities

• Manage Table Authorities

• Manage Plan Authorities

• Manage Package Authorities

• Manage Database Authorities

• Manage Procedure Authorities

• Manage Function Authorities

• Manage Sequence Authorities

• Details of Database

• Tablespaces within Database

• Authorities on Database

• Create / Alter Database

• Generate DDL for Database (including Tablespaces and Tables)

• Administer Authorities for Database

• Compare Databases

• Tablespace Partitions

• Volumes

• Sequence Properties

• Full Details of Sequence

• Authorities on Sequence

• Create / Alter Sequence

• Generate DDL for Sequence

• Manage Sequnce comments

• Administer Authorities for Sequence

• Compare Sequences

List Displays

• List of all Objects (Tables, Views, Aliases, Physicals, Logicals)

• List of Objects with Comments

• List of Objects with System table Name

Details Display

• Columns

• Columns with System Names

• Primary Key

• Indexes

• Check Constraints

• All Constraints

• Views on Table

• Aliases on Table

• Triggers on Table

• Triggers involving Table

• Referenced Tables (foreign keys)

• Dependent Tables

• Create / Alter / Drop / Redefine Table

• Create View on table

• Create Primary Key / Index / Unique Constraint on Table

• Create Foreign Key on Table

• Create Trigger on Table

• Create Check Constraint on Table

• Create Alias on Table

• Generate DDL for Table and related indexes, keys, views, triggers, constraints, aliases

• Compare Tables definitions

• Manage Table Descriptions

• Manage Table Comments

• Manage column Descriptions

• Manage column Comments

• Manage column Headings

• Rename table/s

• Columns

• Columns with System Names

• View Definition

• Views on View

• Objects in View

• Aliases on View

• Triggers on View

• Create / Drop / Redefine View

• Generate DDL for View

• Compare View definitions

• Manage View Descriptions

• Manage View Comments

• Manage column Comments

• Columns

• Columns with System Names

• Full Details of Alias

• Views on Alias

• Create / Drop Alias

• Generate DDL for Alias

• Manage Alias Descriptions

• Columns

• Columns with System Names

• Key Fields

• Indexes

• Check Constraints

• All Constraints

• Views on File

• Aliases on File

• Files Dependent on this

• Files this Depends on

• Triggers on File

• Triggers involving File

• Columns

• Columns with System Names

• Views on File

• Objects in File

• Aliases on File

• Files Dependent on this

• Files this Depends on

• Package Detail

• Rebind / Drop Package

• Manage Package Comments

• Columns

• Columns with Description

• Indexed Table

• Index Details

• Create / Drop Index

• Create Primary Key

• Generate DDL for Index

• Manage Index Comments

• Routine Parameters

• Result Columns

• Routine Detail

• Routine Text

• Create / Alter / Drop Routine

• Create External and SQL Routine

• Compare Routines

• Manage Routine Comments

• Trigger Detail

• Trigger Text

• Referenced Columns

• Dependent Objects

• Update-trigger columns

• Create / Redefine / Drop Trigger

• Generate DDL for Trigger

• Compare Triggers

• Manage Trigger Descriptions

• Sequence Detail

• Create / Alter Sequence

• Generate DDL for Sequence

Display

Actions

List Displays

• List of objects (Tables, View, Synonyms)

• List of of objects with Description

• List of objects with Date Created

• List of Tables with Table Sizing

• List of Tables with Table Status

• List of Dropped Tables

• List of Invalid Objects

• List Synonyms on remote databases

Details Display

• Columns

• Column Statistics

• Columns including Hidden/Virtual columns

• Primary key

• Indexes

• Unique columns

• All Constraints

• Table Status

• Table Extents

• Table Partitions

• Table Privileges (involving you)

• Table Privileges (by all)

• Objects Referencing Table

• Synonyms on Table

• Triggers on Table

• Referenced Tables (foreign keys)

• Dependent Tables

• Create / Alter / Drop / Redefine Table

• Create View on table

• Create Primary Key / Index on Table

• Create Foreign Key on Table

• Create Trigger on Table

• Create Check Constraint on Table

• Create Synonym on Table

• Generate DDL for Table and related indexes, keys, views, triggers, constraints, aliases

• Compare Tables definitions

• Manage Table Comments

• Manage Column Comments

• Rename table/s

• Analyze Table/s

• Truncate Table/s

• Validate Table/s

• Lock Table

• Shrink Table/s

• Move Tablespace for Table

• Analyze Table by Partition

• Enable Constraints

• Disable Constraints

• Encrypt Column

• Administer Authorities for Table

Display

Actions

• Columns

• View Definition

• Details of View

• Objects Referencing View

• Synonyms on View

• Objects in View

• Status of View

• View Privileges (involving you)

• View Privileges (by all)

• Create / Redefine / Drop View

• Generate DDL for View

• Compare View definitions

• Manage Comments for Views

• Manage Comments for View Columns

• Compile View

• Administer Authorities for View

Display

Actions

• Columns

• Synonym Definition

• Status of Synonym

• Synonym Privileges (involving you)

• Synonym Privileges (by all)

• Create / Drop / Synonym

• Create Remote Synonym

• Generate DDL for Synonym

• Administer Authorities for Synonym

Display

Actions

• List of User and DBA items

• Details of Dropped object

• Purge Dropped Object

• Restore Dropped Object

Display

Actions

List Displays

• List of Indexes

• List of Indexes with Type and Status

• List of Dropped Indexes

Detail Displays

• Index Columns

• Details of Index

• Create / Drop Index

• Create Primary Key

• Generate DDL for Index

• Analyze Index

• Rebuild Index

Display

Actions

List Displays

• List of Triggers with Status

• List of Triggers with Date Created

• List of Disabled Triggers

• List of Invalid Triggers

Detail Displays

• Details of Trigger

• Trigger Text

• Trigger Columns

• Objects Referenced by Trigger

• Objects Referencing Trigger

• Compilation Errors

• Create / Redefine / Drop Trigger

• Generate DDL for Trigger

• Compare Trigger Definitions

• Rename Trigger/s

• Enable Trigger/s

• Disable Trigger/s

• Compile Trigger/s

Display

Actions

List Displays

• List of Tablespaces with Status

• List of Tablespaces with Space Usage

Detail Displays

• Details of Tablespace

• Tables within Tablespace

• Indexes within Tablespace

• User Quotas

• Tablespace File Usage

• Segments

• Create / Alter Tablespace

• Generate DDL for Tablespace (including tables)

• Compare Tablespace Definitions

• Set offline Tablespace/s online

• Change Tablespace State

Display

Actions

• Details of User

• Table authorities (involving you)

• Procedure authorities (involving you)

• Table authorities (all)

• Procedure authorities (all)

• System Privileges

• Roles

• Tablespace Quotas

• Create / Alter / Drop / User

• Generate DDL for User

• Compare User definitions

• Manage Table/View/Synonym authorities

• Manage Procedure authorities

• Manage Roles for User

• Manage System Privileges for User

Display

Actions

• Users with Role

• Table authorities

• Procedure authorities

• System Privileges

• Create / Alter / Drop Role

• Generate DDL for Role

• Manage Table/View/Synonym authorities

• Manage Procedure authorities

• Manage Roles for Roles

• Manage members of Role

• Manage System Privileges for User

Display

Actions

List Displays

• List of Functions

• List of Functions with Date Created

• List of Invalid Functions

Detail Displays

• Details of Function

• Function Text

• Objects Referenced by Function

• Objects Referencing Function

• Compilation Errors

• Create / Alter / Drop Function

• Generate DDL for Function

• Compare Function definitions

• Compile Function

Display

Actions

List Displays

• List of Procedures

• List of Procedures with Date Created

• List of Invalid Procedures

Detail Displays

• Procedures Parameters

• Details of Procedure

• Procedure Text

• Objects Referenced by Procedure

• Objects Referencing Procedure

• Compilation Errors

• Privileges of Procedure (involving you)

• Privileges of Procedure (all)

•  

• Create / Alter / Drop Procedure

• Generate DDL for Procedure

• Compare Procedure definitions

• Compile Procedure

• Manage Authorities for Procedure

Display

Actions

List Displays

• List of Packages

• List of Packages with Date Created

• List of Invalid Packages

Detail Displays

• Procedures Parameters

• Details of Procedure

• Procedure Text

• Objects Referenced by Procedure

• Objects Referencing Procedure

• Compilation Errors

• Privileges of Procedure (involving you)

• Privileges of Procedure (all)

•  

• Create / Alter / Drop Package

• Create / Alter Package Body

• Generate DDL for Package

Display

Actions

• Details of Sequence

• Objects Referencing Sequence

• Create / Alter / Drop Sequence

• Generate DDL for Sequence

Display

Actions

• Details of Snapshot

• Snapshot text

• Create / Alter / Drop Snapshot

• Generate DDL for Snapshot

• Refresh Snapshot

Display

Actions

• Details of Type

• Columns comprising Type

• Methods of Type

• Text of Type

• Compilation errors

• Table / View column using Type

• Objects Referenced by Type

• Objects Referencing Type

• Create / Alter / Drop Sequence

• Generate DDL for Sequence

Object

• DBLinks

• Dimensions

• XML Tables

• Jobs

• Scheduler Jobs

Display

Actions

List Displays

• List of Tables/Views

• List of Tables/Views with Description

• List of Tables with Table Sizing

• List of Tables with TOAST table

Details Display

• Columns

• Column Extended Info

• Column Statistics

• Table Statistics

• Table IO statistics

• Primary Key Columns

• Indexes

• Check Constraints

• Authorities on Table

• Views on Table

• Triggers

• Referenced Tables (Foreign Keys)

• Dependent Tables

• Table Partitions

• Tables inherited from (parents)

• Inheriting tables (children)

• Create / Alter / Drop Table

• Create View on table

• Create Primary Key / Index on Table

• Create Foreign Key on Table

• Create Trigger on Table

• Create Check Constraint on Table

• Generate DDL for Table and related indexes, keys, views, triggers, constraints

• Compare Tables comments

• Manage table comments

• Manage column comments

• Rename table/s

• Rename columns

• Analyze Table/s

• Truncate Table/s

• Cluster table/s

• Enable / Disable Triggers

• Move to new Tablespace

• Vacuum Table/s

• Reindex Table/s

Display

Actions

• Columns

• View Definition

• Objects referenced by View

• Views on View

• Authorities on View

• Create / Alter / Drop View

• Generate DDL for View

• Compare View definitions

• Manage View comments

• Manage column comments

• Rename columns

Display

Actions

• Columns

• Definition of Materialized View

• Indexes

• Views on Materialized View

• Objects referenced by Materialized View

• Views on Materialized View

• Authorities on Materialized View

• Create / Alter / Drop Materialized View

• Generate DDL for Materialized View

• Manage Materialized View comments

• Manage column comments

• Rename Materialized View/s

• Rename columns

• Analyze Materialized View/s

• Cluster Materialized View/s

• Move to new Tablespace

• Vacuum Materialized View/s

• Reindex Materialized View/s

• Refresh Materialized View

Display

Actions

• Index Text

• Index Statistics

• Create / Drop Index

• Generate DDL for Index

• Manage Index comments

• Rename index

• Move to new tablespace

• Reindex Index

Display

Actions

• Tablespace details including Location

• Tables in Tablespace (with sizing)

• Indexes in Tablespace (with sizing)

• Create Tablespace

Display

Actions

• Detail of User/Role

• Members of Role

• Roles this user/role belongs to

• Table Authorities

• Routine Authorities

• Usage Authorities

Display

Actions

List Displays

• List of User Triggers

• List of User Triggers with Descriptions

• List of Disabled Triggers

• List of All Triggers

• List of All Triggers with Events

Details Display

• Trigger Details

• Trigger Function Text

• Create / Redefine / Drop Trigger

• Compare Trigger definitions

• Manage Trigger comments

• Enable / Disable Trigger/s

Display

Actions

• Routine Text

• Routine Parameters

• Details of Routine

• Authorities on Routine

• Create / Redefine / Drop Routine

• Generate DDL for Routine

• Compare Routine definitions

• Manage Function comments

Display

Actions

• Details of Sequence

• Columns using Sequence

• Create / Alter / Drop Sequence

• Generate DDL for Sequence

Display

Actions

List Displays

• List of objects (Tables, View, Synonyms)

• List of objects with Description

• List of objects with Date Created / Altered

• List of Tables with Table Sizing

• List of objects with Object-Id

Details Display

• Columns

• Column Descriptions

• Column Defaults

• Columns Rules / Domains

• Identity column info

• Primary Key columns

• Indexes

• Check Constraints

• Unique Constrains

• Authorities on Table

• Objects Referencing Table

• Triggers on Table

• Referenced Tables (foreign keys)

• Dependent Tables

• Create / Alter / Drop / Redefine Table

• Create View on table

• Create Primary Key / Index on Table

• Create Foreign Key on Table

• Create Trigger on Table

• Create Check Constraint on Table

• Generate DDL for Table and related indexes, keys, views, triggers, constraints

• Compare Tables definitions

• Manage Table Descriptions

• Manage Column Descriptions

• Rename table/s

• Rename columns

• Update Statistics for Table/s

• Truncate Table/s

• Change Table Schema

• Enable/Disable all Triggers on Table

• Rebuild selected Indexes on Table

• Rebuild all Indexes on Table/s

• Administer Authorities for Table

Display

Actions

• Columns

• View Definition

• Indexes

• Authorities on View

• Objects Referenced by View

• Objects Referencing View

• Create / Alter / Drop View

• Create Index on View

• Generate DDL for View

• Compare View definitions

• Manage View Descriptions

• Rename view/s

• Change View Schema

• Administer Authorities for View

Display

Actions

• Columns

• Base Object

• Authorities on Synonym

• Objects Referenced by Synonym

• Objects Referencing Synonym

• Manage Synonym Descriptions

Display

Actions

• Index Details

• Index Columns

• Create / Alter / Drop Index

• Generate DDL for Index

• Rebuild Index

Display

Actions

• Trigger Text

• Trigger Event detail

• Objects Referenced by Trigger

• Create / Alter / Drop Trigger

• Generate DDL for Trigger

• Compare Trigger definitions

• Rename trigger/s

• Enable / disable trigger/s

Display

Actions

• Routine Text

• Routine Parameters

• Routine Detail

• Authorities on Routine

• Objects Referenced by Routine

• Objects Referencing Routine

• Create / Alter / Drop Routine

• Generate DDL for Routine

• Compare Routine definitions

• Rename routine/s

• Change procedure schema

• Manage Authorities on routine

Display

Actions

• Rule Text

• Details of Rule

• Columns using Rule

Display

Actions

• Default Text

• Details of Default

• Columns using Default

• Create / Drop Default

• Generate DDL for Default

Display

Actions

List Displays

• List of Database Users

• List of Database Users with Login

• List of Server Users

Details Display

• Details of User

• Table Authorities for User

• Procedure Authorities for User

• Function Authorities for User

• Roles for User

• Login for User

• Create / Alter / Drop User

• Generate DDL for User

• Manage Table Authorities

• Manage Procedure Authorities

• Manage Function Authorities

• Manage Roles for User

Display

Actions

List Displays

• List of Database Roles

• List of Server Roles

Details Display

• Details of Role

• Table Authorities for Role

• Procedure Authorities for Role

• Function Authorities for Role

• Members of Role

• Create / Drop Role

• Create Application Role

• Create Server Role

• Generate DDL for User

• Manage Table Authorities

• Manage Procedure Authorities

• Manage Function Authorities

• Manage Roles for Role

• Manage members of Role

Display

Actions

List Displays

• List of Database Logins

• List of Database Logins with Status

• List of All Logins

Details Display

• Details of Login

• User for Login

• Create Window Authenticated Login

• Create SQL Server Login

• Alter / Drop Login

• Generate DDL for Login

• Grant Login access to this Database

• Change Login password

Display

Actions

• Details of Type

• Columns using Type

• Create / Drop Type

• Generate DDL for Login

• Compare Type

Display

Actions

List Displays

• List of Tables/Views

• List of Tables with Table Sizing

• List of Tables/Views with Date Created/Altered

Details Display

• Columns

• Column with Character Sets

• Table Status Statistics

• Primary Key Columns

• Indexes

• Unique Constraints

• Table Create Statement

• Authorities on Table

• Referenced Tables (Foreign Keys)

• Dependent Tables

• Create / Alter / Drop Table

• Create View on table

• Create Primary Key / Index on Table

• Create Foreign Key on Table

• Create Trigger on Table

• Generate DDL for Table and related indexes, keys

• Administer Authorities for Table

• Compare Tables definitions

• Rename table/s

• Rename columns

• Manage table descriptions

• Analyze table/s

• Optimize table/s

• Truncate table/s

• Enable / disable keys

Display

Actions

• Columns

• View Text

• Create / Drop View

• Generate DDL for View

Display

Actions

• Trigger Definition

• Trigger Details

• Create / Alter / Drop Trigger

• Generate DDL for Trigger

• Compare Trigger definition

Display

Actions

• Routine Definition

• Routine Details

• Authorities on Routine

• Create / Alter / Drop Routine

• Generate DDL for Routine

• Compare Routine definition

• Manage Authorities for Routine

• Manage Routine descriptions

Display

Actions

• Details of User

• Routine Details

• Table Authorities for User

• Procedure Authorities for User

• Function Authorities for User

• Show Grant Statements for User

• Create / Alter / Drop User

• Manage Table Authorities for User

• Manage Global Authorities for users

• Manage Database Authorities for users