SELECT grantee, owner, table_name, select_priv, insert_priv, delete_priv, update_priv, references_priv, alter_priv, index_priv, 'revoke select on ' || table_name || ' from ' || grantee || ';'
FROM table_privileges
WHERE owner = '<owner>'
ORDER BY owner, table_name;

Dodaj komentarz Anuluj pisanie odpowiedzi