Neoview Database Administrator's Guide (R2.3)

See...To...
“Displaying Schemas and Their Objects” (page 36)Create additional schemas
“Displaying Schemas and Their Objects” (page 36)Display lists of schemas
Working With Tables
Your Neoview platform is not preconfigured with tables, but you can create them immediately.
See...To...
“Creating Tables ” (page 43), “Creating Tables From Existing Tables” (page 47),
“Creating Tables Using the Create Table Tool” (page 48)
Create a table
“Granting and Revoking Access (Privileges) to a Table” (page 50)Manage access privileges to
tables
“Adding Columns to a Table” (page 55)Add columns to a table
Working With User IDs
See...To...
“Understanding Roles and User IDs” (page 21)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 23)Change role password and
expiration date
“Deleting a Role” (page 24)Delete roles
“Creating a New User ID” (page 25)Create additional user IDs
“Changing the Password and Expiration Date of a User” (page 26)Change user ID password and
expiration date
“Deleting a User ID” (page 27)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:
18 Getting Started