Add a role – HP Neoview Release 2.5 Software User Manual
Page 97
5.
Click [ View SQL Privileges ]. The SQL Privileges dialog box appears, displaying the
following privilege information for the selected role:
•
SCHEMA NAME
•
OBJECT NAME
•
OBJECT TYPE
•
GRANTED BY
•
PRIVILEGE TYPE
•
COLUMN NAME
NOTE:
The PRIVILEGE TYPE column indicates whether the privilege is a schema privilege
or a column privilege. For a column privilege, the COLUMN NAME column displays Update
or Reference as the privilege.
Add a Role
Before adding a role, review these considerations:
•
To add a new role, you must be a user in the role of ROLE.MGR.
•
You must precede the role name with the ROLE. prefix.
•
The part of the role name that follows the prefix consists of 1 to 8 alphanumeric characters,
the first of which may not be a number.
•
The alphabetic characters in role names are not case-sensitive.
•
HPDM allows you to add multiple roles separated by a comma.
•
The Neoview platform supports a maximum of 255 roles, but three of these roles (ROLE.MGR,
ROLE.DBA, and ROLE.SECMGR) are reserved, so you can create a maximum of 252 new
roles. (You cannot use the name of an existing role when adding a new role.)
•
The role(s) that you add using the Add Role(s) dialog box do not have passwords or
password-expiration criteria. Only the preconfigured roles have passwords.
To add a role or multiple roles:
1.
Log on as a user belonging to ROLE.MGR. For more information about logging on, see
“Connect to a System” (page 25)
.
2.
Select the Security area. For more information about areas, see
3.
In the navigation tree pane, select the Roles folder. The right pane shows the list of roles.
4.
Use one of these methods to display the Add Role(s) dialog box:
•
In the right pane, click [ Add ].
•
In the navigation tree pane, right-click the Roles folder, and select Add Role.
5.
In the Add Role(s) dialog box, type the name of a role, or type multiple role names separated
by commas:
Example of Single Role Name
ROLE.ITDBA
Example of Multiple Role Names Separated by Commas
ROLE.ITOPS, ROLE.SARA, ROLE.BOSTON4
6.
Click [ OK ] to add the role(s). The right pane displays the new roles momentarily.
Related Topics
“About Roles” (page 95)
“Display the Users Who Belong to a Role” (page 96)
“Grant a Role to a User” (page 98)
Add a Role
97