0 comments

PeopleSoft Tables with Public privilege

SELECT table_schema  GRANTOR, PRIVILEGEFROM all_TAB_PRIVSWHERE GRANTEE = 'PUBLIC'AND GRANTOR  <> 'SYS'AND GRANTOR  <> 'SYSTEM'and table_schema = 'SYSADM'order by 1,2,3,4; ...