Reorganized a table and received the following message: "Aborted - ORA-01749: you may not GRANT/REVOKE privileges to/from yourself"
Owner of the object has been granted a privileges to the object.
For example:
SQL> select grantee, privilege from dba_tab_privs where owner = 'AGR_CADASTRO' and table_name = 'CAD_PRODUTO';
GRANTEE PRIVILEGE
------------------------------ ----------------------------------------
AGR_BI SELECT
AGR_CADASTRO SELECT <===== AGR_CADASTRO is owner of CAD_PRODUTO, but it has been granted select on the object.
AGR_DBA SELECT
AGR_RELATORIOS SELECT
Log in oracle as a user (sys or system) who has "revoke any roles or privileges". Revoke privileges on the object from the object owner.
For example:
revoke select on AGR_CADASTRO.CAD_PRODUTO from AGR_CADASTRO;