Neoview Database Administrator's Guide (R2.4)

refresh materialized views, 89
update statistics, 89
P
Passwords, changing
expiration, 24, 27
roles, 24
security considerations, 16
security policies, 30
super ID, 97
users, 27
Performance
log inserts only, 48
Populate index, 63
Privileges, granting/revoking access to schemas, 43
Privileges, granting/revoking access to tables, 52
R
Reconfiguring client data sources, 113
Recovery
data, 95
Refresh materialized view groups operation, 89
Refresh materialized views operation, 89
Removing client data sources, 113
Renaming
views, 71
REORG operation, automating (see Automated REORG)
revokeRole command
syntax of, 128
Roles
changing passwords and expiration dates, 24
creating, 23
deleting, 25
preconfigured, 21
relationship to user IDs, 21
typical usage, 22
S
SCHEDULE command, 110
Schemas
creating, 42
DB
creating tables, 21, 22
description of, 18, 38
displaying, 38
displaying DDL, 43, 44
dropping (deleting), 44
granting/revoking access privileges, 43
preconfigured, 18
USR
creating tables, 21, 22
description of, 18, 38
Screen shots
adding columns to a table, 47
adding roles, 23
adding user IDs, 26
Alter Synonym Wizard, 84
changing
a role’s password, 24
a user ID’s password, 27
Create Index Wizard
defining columns, 62
entering name, 61
unique, 61
Create Materialized View Wizard
entering attributes, 73, 75
entering DDL, 73, 76
entering name, 72, 75, 79
Create Schema Wizard, 42
Create Synonym Wizard
select table, 82
synonym name, 82
Create Table Tool
import DDL, 52
starting, 51
Create Table Using Wizard
choosing base table, 50
entering name, 49
Create Trigger Wizard
define search condition, 67
defining action, 67
defining granularity, 66
defining name, 65
defining search condition, 67
defining time, 66
Create View Wizard
entering DDL, 70
entering name, 70
creating
materialized view groups, 79
materialized views, 72, 75
schemas, 42, 51
tables, 45
triggers:action, 67
triggers:granularity, 66
triggers:name, 65
triggers:search, 67
triggers:time, 66
deleting
roles, 25
user IDs, 28
displaying
attributes of a table, 54
columns of a table, 54
DDL for a schema, 44
DDL for a synonym, 83
DDL for a table, 56, 57
DDL for all tables, 56
hash key for a table, 54
indexes, 64
materialized view groups, 80
materialized views, 77
operations:list, 90
operations:properties, 91
operations:schedule, 93
primary key of a table, 54
privileges for a table, 56
schema materialized view groups, 40
139