SELECT *
FROM dba_tab_privs
WHERE OWNER = 'sys'
AND TABLE_NAME = 'TABELA';
SELECT 'grant '||privilege||' on '||owner||'.'||table_name||' to '||grantee||';'
FROM dba_tab_privs
WHERE grantee = upper('&1')
ORDER BY grantee;
SELECT privilege, owner, table_name, grantee
FROM dba_tab_privs
WHERE grantee= 'ORWMSSEL'
//CONCEDER
SELECT 'grant ' ||privilege||' on '||owner||'.'||table_name||' to '||grantee||';' FROM dba_tab_privs p where p.owner = 'XXX' ORDER BY grantee;
//REVOGAR
SELECT 'REVOKE '||privilege||' on '||owner||'.'||table_name||' FROM '||grantee||';' FROM dba_tab_privs p where p.owner = 'XXX' ORDER BY grantee;