Neoview Database Administrator's Guide (R2.2)

is assigned to the DBA role. The initial password is hp4Binfo.
This user ID is provided as a convenience. HP recommends that you create your
own user IDs based on the DBA role and use them on your system. For additional
security, change this ID’s password.
ROLE.DBA
is assigned to the USER role. The initial password is hp4Binfo.
This user ID is provided as a convenience. HP recommends that you create your
own user IDs based on the USER role and use them on your system. For additional
security, change this ID’s password.
ROLE.USER
can create and alter roles and user IDs.Any user ID
assigned to the
MGR role...
Thereafter
can create tables in the DB schema.Any user ID
assigned to the
DBA role...
can create tables in the USR schema.Any user ID
assigned to the
USER role...
Using Roles to Perform Tasks
Initially, the database administrator logs on using the ROLE.MGR user ID and a valid password.
After user IDs are assigned, users with valid passwords log on using a user ID that is assigned
to the MGR role.
The database administrator creates a new user ID and assigns a role to the user ID. (If a new role
is required, the administrator first creates the role and then creates the user ID and assigns the
new role.)
Any user who creates a table in the database (and is, therefore, the table owner) grants (or revokes)
access privileges to one or more roles.
Example Scenario
Suppose you are setting up your system. You will need to have some users who can access payroll
information, and others who can access customer information. You create roles for these tasks,
assign access privileges to these roles, then add user IDs assigned to these roles.
You might create one user ID, assigned to the role PAY, to access payroll information, and another
user ID, assigned to the role CST, to access customer account information.
In this scenario, the role PAY is granted access to tables containing payroll information, and the
role CST is granted access to tables containing customer account information. Any user IDs
assigned to these roles have the access privilege granted to that role.
Example: Create new roles:
1. Log on to DB Admin using the ROLE.MGR user ID.
2. Click the Users tab, then the Add/Alter tab, then select Add Role.
3. Add roles for each user task, for example PAY and CST.
Example: Grant access privileges:
1. Log on as the ROLE.DBA user ID.
2. Click the Database tab, navigate to the payroll table, then select Grant/Revoke privileges.
3. Enter the required information and click OK. Role PAY now has the access privileges you
have configured.
4. Repeat this for the role called CST with the customer table.
For details, see “Granting and Revoking Access (Privileges) to a Table” (page 47).
24 Managing Roles, User IDs, and Linux Accounts