Neoview Database Administrator's Guide (R2.4)

Working With Tables
Your Neoview platform is not preconfigured with tables, but you can create them immediately.
See...To...
“Creating Tables ” (page 45), “Creating Tables From Existing Tables” (page 49),
“Creating Tables Using the Create Table Tool” (page 50)
Create a table
“Granting and Revoking Access (Privileges) to a Table” (page 52)Manage access privileges to
tables
“Adding Columns to a Table” (page 57)Add columns to a table
Working With User IDs
See...To...
“Understanding Roles and User IDs” (page 22)Understand the relationship of
roles and user IDs
“Creating a New Role” (page 23)Create additional roles
“Changing the Password and Expiration Date of a Role” (page 24)Change role password and
expiration date
“Deleting a Role” (page 25)Delete roles
“Creating a New User ID” (page 26)Create additional user IDs
“Changing the Password and Expiration Date of a User” (page 27)Change user ID password and
expiration date
“Deleting a User ID” (page 28)Delete user IDs
Stored Procedures
The Neoview platform supports stored procedures in Java. For more information, refer to the
Neoview Guide to Stored Procedures in Java.
Scripting Support
The Neoview platform supports a client-based utility, Neoview Command Interface (NCI), which
enables you to enter SQL statements interactively or from script files in its command-line interface.
You can also pass an SQL statement to NCI from a Perl or Python command line or from a Perl
or Python program. For more information, see the Neoview Command Interface (NCI) Guide.
System Name Display and Logon Help Link
The DB Admin tool displays the user ID of the user who is logged on. In addition, HP support
or users in the role.mgr group can edit a configuration file so that the system’s name is displayed.
You can customize a link from the DB Admin start page to a web page containing help for DB
Admin users. For example, you might want to provide help in logging on to the system or help
for users who have forgotten their passwords. For example:
Working With Tables 19