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  Back

KPVIEW_USER_USERGROUP