I think i figured it out..
SELECT 'GRANT SELECT ON '||uo$.name||'.'||o$.name||' TO '||ue$.name STMT
FROM sys.objauth$ t$, sys.obj$ o$, sys.user$ ur$,
sys.table_privilege_map m$, sys.user$ ue$, sys.user$ uo$
WHERE o$.obj# = t$.obj#
AND t$.privilege# = m$.privilege
AND t$.col# IS NULL
AND t$.grantor# = ur$.user#
AND t$.grantee# = ue$.user#
and o$.owner#=uo$.user#
and ur$.name = 'RTDATE'
and uo$.name = 'RTDATE'
and o$.name like '%SEQ%'
/




Reply With Quote