Neoview Database Administrator's Guide (R2.3)

Table of Contents
About This Manual.............................................................................................................9
Who Should Use This Manual................................................................................................................9
New and Changed Information in This Edition.....................................................................................9
Related Documentation..........................................................................................................................9
Neoview Customer Library...............................................................................................................9
Notation Conventions...........................................................................................................................11
Hypertext Links...............................................................................................................................11
General Syntax Notation.................................................................................................................11
Change Bar Notation.......................................................................................................................11
Publishing History................................................................................................................................11
HP Encourages Your Comments..........................................................................................................11
1 Introduction to the HP Neoview Platform...................................................................13
About This Guide..................................................................................................................................13
For More Information ..........................................................................................................................13
For Additional Help..............................................................................................................................13
2 Getting Started.............................................................................................................15
Security Considerations........................................................................................................................15
Neoview User Roles and IDs...........................................................................................................15
Java Considerations..............................................................................................................................16
U.S. Daylight Saving Time (DST) Changes in 2007.........................................................................16
Management Tools................................................................................................................................17
Starting the Neoview DB Admin Tool..................................................................................................17
Working With Schemas.........................................................................................................................17
Working With Tables.............................................................................................................................18
Working With User IDs.........................................................................................................................18
Stored Procedures.................................................................................................................................18
Scripting Support..................................................................................................................................18
System Name Display and Logon Help Link.......................................................................................18
3 Managing Roles, User IDs, and Linux Accounts.......................................................21
Understanding Roles and User IDs......................................................................................................21
Roles ................................................................................................................................................21
User IDs...........................................................................................................................................21
Using Roles to Perform Tasks..........................................................................................................22
Creating a New Role.............................................................................................................................23
Changing the Password and Expiration Date of a Role.......................................................................23
Deleting a Role......................................................................................................................................24
Creating a New User ID........................................................................................................................25
Changing the Password and Expiration Date of a User.......................................................................26
Deleting a User ID.................................................................................................................................27
Viewing User Status..............................................................................................................................28
Managing Security Policies...................................................................................................................29
4 Planning Your Database..............................................................................................31
Guidelines for Database Administrators..............................................................................................31
Neoview SQL Table Options.................................................................................................................31
Table of Contents 3