Neoview Database Administrator's Guide (R2.4)

Changing the Password and Expiration Date of a Role.......................................................................24
Deleting a Role......................................................................................................................................25
Creating a New User ID........................................................................................................................26
Changing the Password and Expiration Date of a User.......................................................................27
Deleting a User ID.................................................................................................................................28
Viewing User Status..............................................................................................................................29
Managing Security Policies...................................................................................................................30
Rules for Passwords.........................................................................................................................31
4 Planning Your Database..............................................................................................33
Guidelines for Database Administrators..............................................................................................33
Neoview SQL Table Options.................................................................................................................33
5 Managing Database Objects.....................................................................................37
Schemas.................................................................................................................................................38
Displaying Schemas and Their Objects...........................................................................................38
Creating Schemas............................................................................................................................42
Granting and Revoking Access (Privileges) to a Schema................................................................43
Displaying Schema DDL Information.............................................................................................43
Dropping (Deleting) Schemas.........................................................................................................44
Tables.....................................................................................................................................................44
Creating Tables ...............................................................................................................................45
Creating Tables From Existing Tables.............................................................................................49
Creating Tables Using the Create Table Tool...................................................................................50
Granting and Revoking Access (Privileges) to a Table....................................................................52
Displaying Tables and Their Properties..........................................................................................53
Displaying Table DDL Information.................................................................................................56
Adding Columns to a Table.............................................................................................................57
Changing Table Attributes..............................................................................................................58
Changing Table Columns................................................................................................................59
Renaming Tables..............................................................................................................................59
Enabling or Disabling Reorganize and Update Statistics on Tables...............................................60
Dropping (Deleting) Tables.............................................................................................................60
Indexes..................................................................................................................................................61
Creating Indexes..............................................................................................................................61
Displaying Indexes and Their Properties........................................................................................64
Dropping (Deleting) Indexes...........................................................................................................64
Triggers.................................................................................................................................................65
About Triggers.................................................................................................................................65
Creating Triggers on Tables.............................................................................................................65
Displaying Triggers and Their Properties.......................................................................................68
Enabling or Disabling Triggers on Tables........................................................................................69
Views.....................................................................................................................................................69
Creating Views................................................................................................................................69
Displaying Views and Their Properties..........................................................................................70
Renaming Views..............................................................................................................................71
Dropping (Deleting) Views.............................................................................................................72
Materialized Views...............................................................................................................................72
Creating Materialized Views...........................................................................................................72
Displaying Materialized Views and Their Properties.....................................................................77
Changing Materialized Views.........................................................................................................78
Dropping (Deleting) Materialized Views........................................................................................79
Materialized View Groups....................................................................................................................79
4 Table of Contents