Extracting Sequences and GRANTS

[Dilippatel]

jmodic,

Little correction with your Query.

SELECT 'GRANT '||privilege||' ON '||p.owner||'.'||p.table_name||' TO '||p.grantee stmt
FROM DBA_TAB_PRIVS p, DBA_SEQUENCES s
WHERE p.owner = s.sequence_owner
AND p.table_name = s.sequence_name
AND s.sequence_owner = 'ABC';

Cheers