List of user groups and the HPD users that belong to them defined on an HPD server schema.
Output
Column | Type | Description |
|---|---|---|
usergroup_id | NUMBER | ID of the user group. |
name | VARCHAR2 | Name of the user group. |
writable | VARCHAR2 | 'Y' if the user has write access to the user group; “N' otherwise. |
user_id | NUMBER | ID of the HPD user. |
username | VARCHAR2 | Name of the HPD user. |
Example
The following example shows the use of this view in an SQL statement.
select * from usergroup_users_vw where user_id=1; |
Exceptions
None defined at this time.