Neoview Database Administrator's Guide (R2.2)

S
Schemas
creating, 39
DB
creating tables, 23, 24
description of, 20, 38
displaying, 38
displaying DDL, 39, 40
dropping (deleting), 40
preconfigured, 20
USR
creating tables, 23, 24
description of, 20, 38
Screen shots
adding columns to a table, 42
adding roles, 25
adding user IDs, 27
age table operation
failure, 81
predicate, 80
schedule, 81
Alter Synonym Wizard, 73
changing
a role’s password, 25
a user ID’s password, 27
Create Index Wizard
defining columns, 58
entering name, 57
unique, 57
Create Materialized View Wizard
entering attributes, 64, 66
entering DDL, 64, 66
entering name, 63, 65, 69
Create Schema Wizard, 39
Create Synonym Wizard
select table, 72
synonym name, 72
Create Table Tool
import DDL, 46
starting, 45
Create Table Using Wizard
choosing base table, 44
entering name, 44
Create Trigger Wizard
define search condition, 55
defining action, 55
defining granularity, 54
defining name, 54
defining search condition, 55
defining time, 54
Create View Wizard
entering DDL, 61
entering name, 61
creating
materialized view groups, 69
materialized views, 63, 65
schemas, 39, 45
tables, 40
triggers:action, 55
triggers:granularity, 54
triggers:name, 54
triggers:search, 55
triggers:time, 54
deleting
roles, 26
user IDs, 28
displaying
attributes of a table, 49
columns of a table, 49
DDL for a schema, 40
DDL for a synonym, 73
DDL for a table, 50, 51
DDL for all tables, 51
hash key for a table, 49
indexes, 60
materialized view groups, 71
materialized views, 68
operations:list, 82
operations:properties, 82
operations:schedule, 83
primary key of a table, 49
privileges for a table, 50
schema objects, 39
schemas, 38
space of a table, 50
stored procedures, 74, 75
super ID status, 87
synonyms, 73
system name, 21
tables, 47
views, 62
dropping
indexes, 60
schemas, 40
tables, 56
event viewer, 88, 90
event viewer links, 90
grant/revoke privileges, 47
help link, 22
indexes
creating, 57
creating unique, 57
defining columns, 58
displaying, 60
dropping, 60
schedule populate index, 59
manage super ID, 87
managing security policies, 30
materialized view groups
changing, 71
creating, 69
displaying, 71
materialized views
changing, 68
displaying, 68
entering attributes, 64, 66
entering DDL, 64, 66
setting ignore changes on, 65, 67
154 Index