Neoview User Management and Security Administration Guide (R2.5)

Parameters
rolename
The role to be assigned as this user's default (or primary) role. A string consisting of the prefix
“ROLE.” followed by 1 to 8 alphanumeric characters, the first of which may not be a number.
username
The name of an existing database user. The name can consist of up to 128 characters.
Error Conditions
If the command is successful, a message is displayed indicating that the role was assigned as the
default role. The command returns an error in any of the following cases:
• The user executing the command is not logged on as either the specified user, as a user with
the role ROLE.MGR.
• The specified user is not registered on the Neoview platform.
• The role parameter does not specify an existing role.
• The specified role is not among the user's secondary roles.
Example
SETDEFAULT ROLE ROLE.DBA, USER BettyBradford
User Management Views
The database views described in this section let you monitor user-management actions and
logins. The views include details of the actions taken and specify which user took each action.
To access the views, you use SQL queries from the Neoview Command Interface (NCI) or any
other standard SQL tool. For example, the query SELECT * from HP_SECURITY.USERINFO
displays all database users, when each user was registered and by whom, the user's default role,
and the time the user last logged on.
By default, only a user who has the role ROLE.SECMGR or ROLE.MGR or who has SUPER.SUPER
or SUPER.SERVICES privileges has unrestricted Select access against the views pertaining to
database users. Any other user can view data pertaining to himself or herself.
By default, only a user who has the role ROLE.MGR or ROLE.SECMGR or who has SUPER.SUPER
or SUPER.SERVICES privileges can execute Select statements against the views pertaining to
platform users. Any platform user can view data pertaining to himself or herself. A user who
has the role ROLE.SECMGR can grant other users access to the ROLEINFO view.
In addition to the views described in this manual, HPDM provides several displays pertaining
to roles:
• The Role Details dialog box lists all users to whom a role is currently assigned.
• The SQL Privileges dialog box lists the SQL privileges associated with a role.
For detailed descriptions of HPDM dialogs, see the HPDM Online Help.
User Information for Database Users (HP_SECURITY.USERINFO)
The user information (USERINFO) view consists of one row per database user. At any given
time, this view reflects all database users defined on the Neoview platform. It excludes platform
users.
If a user is deleted, the user's row is deleted from this view, but changes pertaining to the user
will remain in the USERROLELOG view.
Neoview user names are unique across the platform.
Column Definitions
Each row consists of the following columns:
120 User and Role Management