HP Neoview Release 2.5 Software - Manual (Page 6)

Attributes Tab..................................................................................................................................88
Usage Tab.........................................................................................................................................89
DDL Tab...........................................................................................................................................89
Display Triggers and Their Properties..................................................................................................89
Attributes Tab..................................................................................................................................90
Usage Tab.........................................................................................................................................91
DDL Tab...........................................................................................................................................91
Display Schema DDL and Their Properties..........................................................................................91
DDL Tab...........................................................................................................................................92
Show DDL .......................................................................................................................................92
Display Table Statistics and Their Properties.......................................................................................93
Display Table Column Statistics......................................................................................................93
Viewing Sampled Statistics.............................................................................................................94
7 Manage Roles..............................................................................................................95
About Roles...........................................................................................................................................95
Display All Roles...................................................................................................................................95
Display the Users Who Belong to a Role..............................................................................................96
Display All the Roles for a User............................................................................................................96
Display the SQL Privileges for a Role...................................................................................................96
Add a Role............................................................................................................................................97
Delete a Role.........................................................................................................................................98
Grant a Role to a User...........................................................................................................................98
Use the Grant Role Dialog Box.............................................................................................................99
Revoke a Role From a User...................................................................................................................99
Change the Password or Expiration for a Role...................................................................................100
Use the Change Role Password Dialog Box........................................................................................101
8 Manage Users and Passwords.................................................................................103
About Users.........................................................................................................................................103
Database Users....................................................................................................................................103
Display All Database Users...........................................................................................................103
Add a Database User.....................................................................................................................104
Use the Add Database User Dialog Box........................................................................................105
Use the Select User Role Dialog Box..............................................................................................106
Add Multiple Database Users.......................................................................................................106
Use the Add Multiple Database Users Dialog Box........................................................................107
Copy a Database User....................................................................................................................107
Control the Display of the Add Database User Dialog Box..........................................................108
Change Role or Password Information for a Database User.........................................................109
Use the Edit User Dialog Box........................................................................................................109
Delete One or More Database Users..............................................................................................111
Change Your Own Default Role....................................................................................................111
Platform Users.....................................................................................................................................111
Display All Platform Users............................................................................................................111
Add a Platform User......................................................................................................................112
Copy a Platform User....................................................................................................................112
Use the Add Platform User (or Edit User) Dialog Box..................................................................113
Edit a Platform User......................................................................................................................114
Delete One or More Platform Users..............................................................................................115
Passwords for Users............................................................................................................................115
Change Your Own Password at Logon.........................................................................................115
Change Your Own Password After Logon....................................................................................116
6 Table of Contents