SELECT table_schema
GRANTOR, PRIVILEGE
FROM all_TAB_PRIVS
WHERE GRANTEE = 'PUBLIC'
AND GRANTOR <> 'SYS'
AND GRANTOR <> 'SYSTEM'
and table_schema = 'SYSADM'
order by 1,2,3,4;
SELECT (A.EMPLID)"GPID",
(SELECT PED.ALTER_EMPLID FROM SYSADM.PS_PERS_DATA_EFFDT PED WHERE PED.EMPLID = A.EMPLID AND
PED.EFFDT = (SELECT MAX(PED1.EFFDT) FROM SYSADM.PS_PERS_DATA_EFFDT PED1 WHERE PED1.EMPLID =PED.EMPLID)) "GID",
(A.DT_OF_DEATH)"DATE OF DEATH",B.HR_STATUS
,B.EMPL_RCD,B.EFFDT,B.EFFSEQ,B.ACTION,B.ACTION_REASON,B.REG_REGION
FROM SYSADM.PS_CURRENT_JOB B, SYSADM.PS_PERSON A
WHERE A.EMPLID = B.EMPLID
AND B.REG_REGION IN('AUS','NZL')
AND TRIM(A.DT_OF_DEATH) IS NOT NULL;
