Neoview Database Administrator's Guide (R2.3)

security policies, 29
super ID, 95
users, 26
Performance
log inserts only, 46
Populate index, 61
Privileges, granting/revoking access to schemas, 41
Privileges, granting/revoking access to tables, 50
R
Reconfiguring client data sources, 111
Recovery
data, 93
Refresh materialized view groups operation, 87
Refresh materialized views operation, 87
Removing client data sources, 111
Renaming
views, 69
REORG operation, automating (see Automated REORG)
Roles
changing passwords and expiration dates, 23
creating, 23
deleting, 24
preconfigured, 21
relationship to user IDs, 21
typical usage, 22
S
SCHEDULE command, 107
Schemas
creating, 40
DB
creating tables, 21, 22
description of, 17, 36
displaying, 36
displaying DDL, 41, 42
dropping (deleting), 42
granting/revoking access privileges, 41
preconfigured, 17
USR
creating tables, 21, 22
description of, 17, 36
Screen shots
adding columns to a table, 45
adding roles, 23
adding user IDs, 25
Alter Synonym Wizard, 82
changing
a role’s password, 23
a user ID’s password, 26
Create Index Wizard
defining columns, 59
entering name, 58
unique, 59
Create Materialized View Wizard
entering attributes, 71, 73
entering DDL, 71, 74
entering name, 70, 73, 77
Create Schema Wizard, 40
Create Synonym Wizard
select table, 80
synonym name, 80
Create Table Tool
import DDL, 50
starting, 49
Create Table Using Wizard
choosing base table, 48
entering name, 47
Create Trigger Wizard
define search condition, 65
defining action, 65
defining granularity, 64
defining name, 63
defining search condition, 65
defining time, 64
Create View Wizard
entering DDL, 68
entering name, 68
creating
materialized view groups, 77
materialized views, 70, 73
schemas, 40, 49
tables, 43
triggers:action, 65
triggers:granularity, 64
triggers:name, 63
triggers:search, 65
triggers:time, 64
deleting
roles, 24
user IDs, 27
displaying
attributes of a table, 52
columns of a table, 52
DDL for a schema, 42
DDL for a synonym, 81
DDL for a table, 54, 55
DDL for all tables, 54
hash key for a table, 52
indexes, 62
materialized view groups, 78
materialized views, 75
operations:list, 88
operations:properties, 89
operations:schedule, 91
primary key of a table, 52
privileges for a table, 54
schema materialized view groups, 38
schema materialized views, 37
schema privileges, 37
schema procedures, 39
schema synonyms, 40
schema tables, 37
schema views, 39
schemas, 36
space of a table, 53
stored procedures, 83
super ID status, 95
129