Neoview Database Administrator's Guide (R2.4)

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................................................................................................................................12
HP Encourages Your Comments..........................................................................................................12
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
Limited Access on the Neoview platform.......................................................................................15
Connection Timeout........................................................................................................................15
Neoview User Roles and IDs...........................................................................................................16
About The Super ID...................................................................................................................16
About The Services ID................................................................................................................16
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.........................................................................................................................18
Working With Tables.............................................................................................................................19
Working With User IDs.........................................................................................................................19
Stored Procedures.................................................................................................................................19
Scripting Support..................................................................................................................................19
System Name Display and Logon Help Link.......................................................................................19
3 Managing Roles, User IDs, and Linux Accounts.......................................................21
Introduction to Roles and User IDs......................................................................................................21
Roles ................................................................................................................................................21
User IDs...........................................................................................................................................21
Creating and Managing Users and Roles With DB Admin..................................................................22
Understanding Roles and User IDs......................................................................................................22
Naming Rules for Roles and User IDs.............................................................................................22
Using Roles to Perform Tasks..........................................................................................................22
Example Scenario......................................................................................................................22
Example: Create new roles:...................................................................................................23
Example: Grant access privileges:.........................................................................................23
Example: Create user IDs that use these roles:.....................................................................23
Creating a New Role.............................................................................................................................23
Table of Contents 3