Neoview Database Administrator's Guide (R2.4)

schema materialized views, 39
schema privileges, 39
schema procedures, 41
schema synonyms, 42
schema tables, 39
schema views, 41
schemas, 38
space of a table, 55
stored procedures, 85
super ID status, 97
synonyms, 83
system name, 19
tables, 53
triggers, 68, 69
views, 71
dropping
indexes, 64
schemas, 44
tables, 60
event viewer, 98, 101
event viewer links, 101
grant/revoke privileges, 52
grant/revoke schema privileges, 43
help link, 20
indexes
creating, 61
creating unique, 61
defining columns, 62
displaying, 64
dropping, 64
schedule populate index, 63
manage super ID, 97
managing security policies, 30
materialized view groups
changing, 81
creating, 79
displaying, 80
materialized views
changing, 78
displaying, 77
entering attributes, 73, 75
entering DDL, 73, 76
setting ignore changes on, 74, 76
NDCS data source status, 115
NDCS server status, 116
NDCS status, 115
operations
manage super ID, 97
Rename Table Wizard, 60
Rename View Wizard, 71
renaming
tables, 60
views, 71
roles
adding, 23
changing password, 24
deleting, 25
Schedule Maintain Wizard
defining schedule, 90
select operation, 87
Schedule Populate Index Wizard, 63
schema materialized view groups, 40
schema materialized view groups, displaying, 40
schema materialized views, 39
schema materialized views, displaying, 39
schema privileges, 39
schema privileges, displaying, 39
schema procedures, 41
schema procedures, displaying, 41
schema synonyms, 42
schema synonyms, displaying, 42
schema tables, 39
schema tables, displaying, 39
schema views, 41
schema views, displaying, 41
schemas
creating, 42
displaying, 38
displaying DDL, 44
dropping, 44
security policies, managing, 30
stored procedures
displaying , 85
super ID status, 97
synonyms
changing, 84
creating, 82
displaying, 83
system name display, 19
tables
adding columns, 58
attributes, 48
creating, 45
creating triggers:action, 67
creating triggers:granularity, 66
creating triggers:name, 65
creating triggers:search, 67
displaying , 53
displaying attributes, 54
displaying columns, 54
displaying DDL, 56, 57
displaying hash key, 54
displaying primary keys, 54
displaying privileges, 56
displaying space, 55
displaying triggers, 69
dropping, 60
renaming, 60
triggers
displaying , 68
displaying triggers, 68
user IDs
adding, 26
changing password, 27
deleting, 28
user status
viewing all, 29
viewing by role, 30
140 Index