5a.359. User Groups (OCI360_USER_GROUPS)

#	USER_NAME	USER_DESCRIPTION	GROUP_NAME	GROUP_DESCRIPTION	USER_ID	GROUP_ID
1	oci360_user	Account used for OCI360	oci360_group	Group used for OCI360	ocid1.user.oc1..000000000000000000000000000000000000000000000000000000000687	ocid1.group.oc1..000000000000000000000000000000000000000000000000000000000263
2	[email protected]	Rodrigo Jorge	Administrators	Administrators	ocid1.user.oc1..000000000000000000000000000000000000000000000000000000000690	ocid1.group.oc1..000000000000000000000000000000000000000000000000000000000262
3	[email protected]	Rodrigo Jorge	Administrators	Administrators	ocid1.user.oc1..000000000000000000000000000000000000000000000000000000000689	ocid1.group.oc1..000000000000000000000000000000000000000000000000000000000262

#: click on a column heading to sort on it

 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 ID                                                                                           VARCHAR2(128)
 NAME                                                                                         VARCHAR2(16)
 USER_ID                                                                                      VARCHAR2(128)
 DESCRIPTION                                                                                  VARCHAR2(32)
 DEFINED_TAGS$ORACLE_TAGS$CREATEDBY                                                           VARCHAR2(32)
 DEFINED_TAGS$ORACLE_TAGS$CREATEDON                                                           VARCHAR2(32)
 TIME_CREATED                                                                                 VARCHAR2(32)
 COMPARTMENT_ID                                                                               VARCHAR2(128)
 INACTIVE_STATUS                                                                              VARCHAR2(4)
 LIFECYCLE_STATE                                                                              VARCHAR2(8)


SELECT T2.NAME USER_NAME,
       T2.DESCRIPTION USER_DESCRIPTION,
       T1.NAME GROUP_NAME,
       T1.DESCRIPTION GROUP_DESCRIPTION,
       T2.ID USER_ID,
       T1.ID GROUP_ID
FROM   OCI360_USER_GROUPS t1, OCI360_USERS t2
WHERE  t1.user_id=t2.id;


3 rows selected.