[Home] [Help]
View: IGS_SC_GRANTS_V
Product: | IGS - Student System (Obsolete) |
Description: | Self-Service view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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
Columns
Name |
GRANT_ID |
GRANT_NAME |
LOCKED_FLAG |
USER_GROUP_ID |
USER_GROUP_NAME |
OBJ_GROUP_ID |
GRANT_SELECT_FLAG |
GRANT_INSERT_FLAG |
GRANT_UPDATE_FLAG |
GRANT_DELETE_FLAG |
FUNCTION_ID |
FUNCTION_NAME |
GRANT_TEXT |
CREATION_DATE |
CREATED_BY |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |