This view displays users and the user groups to which they belong. 

 

USER_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier for the user.
This field is a primary key.
 

USERNAME (Oracle = nvarchar2), (SQL = nvarchar)
The name that the user enters to log in to the server.
 

FIRST_NAME (Oracle = nvarchar2), (SQL = nvarchar)
User's first name.
 

LAST_NAME (Oracle = nvarchar2), (SQL = nvarchar)
User's last name.
 

USERGROUP_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier for the user group.
This field is a primary key.
 

USERGROUP_NAME (Oracle = nvarchar2), (SQL = nvarchar)
Name of the user group.


Table of Contents