List of roles assigned to an HPD server user.
Output
Column | Type | Description |
|---|---|---|
user_id | NUMBER | Primary key of HPD user. |
username | VARCHAR2 | Assigned user name. |
role_id | NUMBER | Role ID assigned to user. |
role_name | VARCHAR2 | Name of this assigned role. |
Example
The following example shows the use of this view in an SQL statement.
select * from hpd_user_role_vw where user_id=1; |
Exceptions
None defined at this time.