[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Self-Service view |
| Implementation/DBA Data: | Not implemented in this database |
SELECT GRN.OBJ_GROUP_ID
, GR.GRANT_ID
, GR.GRANT_COND_NUM
, GR.OBJ_ATTRIB_ID
, OBAT.OBJ_ATTRIB_NAME
, GR.USER_ATTRIB_ID
, USAT.USER_ATTRIB_NAME
, GR.CONDITION
, GR.TEXT_VALUE
, GR.CREATION_DATE
, GR.CREATED_BY
, GR.LAST_UPDATED_BY
, GR.LAST_UPDATE_DATE
, GR.LAST_UPDATE_LOGIN
FROM IGS_SC_GRANT_CONDS GR
, IGS_SC_GRANTS GRN
, IGS_SC_USR_ATTRIBS USAT
, IGS_SC_OBJ_ATTRIBS OBAT
WHERE GR.USER_ATTRIB_ID = USAT.USER_ATTRIB_ID (+)
AND GRN.GRANT_ID = GR.GRANT_ID
AND GR.OBJ_ATTRIB_ID = OBAT.OBJ_ATTRIB_ID (+)
AND GRN.OBJ_GROUP_ID = NVL(OBAT.OBJ_GROUP_ID
, GRN.OBJ_GROUP_ID)