Neoview Database Administrator's Guide (R2.2)

2. Log on to DB Admin with a valid user ID and password.
For more information about user IDs, see “Working With User IDs” (page 21).
For detailed descriptions of each window in DB Admin and information about how to
perform other tasks, see DB Admin online help.
Working With Schemas
Your Neoview platform is preconfigured with these schemas:
Is used for...This schema
All tables that database administrators create in the database for end users, including
dimension and fact tables.
DB
All tables created by end users using the Neoview DB Admin tool or third-party tools
that connect to ODBC data sources.
USR
See...To...
“Displaying Schemas and Their Objects” (page 38)Create additional schemas
“Displaying Schemas and Their Objects” (page 38)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 40), “Creating Tables From Existing Tables” (page 44),
“Using the Create Table Tool to Import DDL From a File” (page 45)
Create a table
“Granting and Revoking Access (Privileges) to a Table” (page 47)Manage access privileges to
tables
“Adding Columns to a Table” (page 51)Add columns to a table
20 Getting Started