Neoview Database Administrator's Guide (R2.5)

Neoview Roles and User IDs
Your Neoview system is delivered with a set of preconfigured roles and user IDs with predefined
passwords.
CAUTION: For your system’s security, change these passwords as soon as you receive your
system, using the Neoview Command Interface (NCI).
For detailed information about working with Neoview roles and User IDs, see the Neoview User
Management and Security Administration Guide.
Working With Neoview Roles and User IDs
There are certain role and user ID related tasks you need to perform.
See this documentation...Use this tool...To...
The Neoview User Management and Security Administration GuideN/AUnderstand
Neoview roles
and user IDs
Neoview NCI GuideNCICreate and
manage roles and
user IDs
Neoview NCI GuideNCIChange
passwords and
expiration dates
Management Tools
Use these tools to manage your Neoview platform:
To...Use this tool...
Browse the database: view objects and their properties
Manage data sources and the Neoview Database Connectivity Service (NDCS)
Display attributes, SQL space, and DDL information for database objects
HPDM
Add, configure, and manage ODBC client data sources. HP automatically installs
ODBC components on your Neoview platform. You must install the ODBC client
components on all client workstations that use ODBC data sources.
Microsoft ODBC Database
Administrator
Enter SQL statements interactively or from script files to:
Change passwords
Add/Alter/Delete Users and roles
List users and roles
Manage the Safeguard security policy
Create and drop schemas and other database objects
Pass an SQL statement to NCI from a Perl or Python command line or from
a Perl or Python program.
For information about SQL commands and syntax, refer to the Neoview SQL
Reference Manual.
NCI
Provide insight into queries running on your Neoview platform.
NPAT provides the ability to:
Analyze system and workload metrics
Analyze currently running querie
Analyze historical data
Execute and review explain plans for queries
NPAT
Manage the workload and resources on the Neoview platform.WMS
14 Getting Started