select
USER_NAME,
ROLE_NAME,
USER_ORIG_SYSTEM,
USER_ORIG_SYSTEM_ID,
ROLE_ORIG_SYSTEM,
ROLE_ORIG_SYSTEM_ID,
ROLE_ORIG_SYSTEM,
ROLE_ORIG_SYSTEM_ID,
ASSIGNMENT_TYPE,
START_DATE,
EXPIRATION_DATE,
OWNER_TAG,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
PARTITION_ID,
ASSIGNMENT_REASON
from wf_local_user_roles
SELECT
USER_NAME
,
ROLE_NAME
,
USER_ORIG_SYSTEM
,
USER_ORIG_SYSTEM_ID
,
ROLE_ORIG_SYSTEM
,
ROLE_ORIG_SYSTEM_ID
,
ROLE_ORIG_SYSTEM
,
ROLE_ORIG_SYSTEM_ID
,
ASSIGNMENT_TYPE
,
START_DATE
,
EXPIRATION_DATE
,
OWNER_TAG
,
CREATED_BY
,
CREATION_DATE
,
LAST_UPDATED_BY
,
LAST_UPDATE_DATE
,
LAST_UPDATE_LOGIN
,
PARTITION_ID
,
ASSIGNMENT_REASON
FROM WF_LOCAL_USER_ROLES
|
|
|