SELECT gr.GRANT_ID , gr.GRANT_NAME , gr.LOCKED_FLAG , gr.USER_GROUP_ID , rl.DISPLAY_NAME , gr.OBJ_GROUP_ID , gr.GRANT_SELECT_FLAG, gr.GRANT_INSERT_FLAG, gr.GRANT_UPDATE_FLAG, gr.GRANT_DELETE_FLAG, gr.FUNCTION_ID , '' , gr.GRANT_TEXT , gr.CREATION_DATE , gr.CREATED_BY , gr.LAST_UPDATED_BY , gr.LAST_UPDATE_DATE , gr.LAST_UPDATE_LOGIN FROM igs_sc_grants gr, wf_local_roles rl WHERE rl.ORIG_SYSTEM ='IGS' AND rl.ORIG_SYSTEM_ID=gr.USER_GROUP_ID
SELECT GR.GRANT_ID
, GR.GRANT_NAME
, GR.LOCKED_FLAG
, GR.USER_GROUP_ID
, RL.DISPLAY_NAME
, GR.OBJ_GROUP_ID
, GR.GRANT_SELECT_FLAG
, GR.GRANT_INSERT_FLAG
, GR.GRANT_UPDATE_FLAG
, GR.GRANT_DELETE_FLAG
, GR.FUNCTION_ID
, ''
, GR.GRANT_TEXT
, GR.CREATION_DATE
, GR.CREATED_BY
, GR.LAST_UPDATED_BY
, GR.LAST_UPDATE_DATE
, GR.LAST_UPDATE_LOGIN
FROM IGS_SC_GRANTS GR
, WF_LOCAL_ROLES RL
WHERE RL.ORIG_SYSTEM ='IGS'
AND RL.ORIG_SYSTEM_ID=GR.USER_GROUP_ID
|
|
|