title: ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
body: <p>I am running the below query from <code>RATOR_MONITORING</code> schema which is granting the reference permission from <code>RATOR_MONITORING_CONFIGURATION.SMSC_GATEWAY</code> table to <code>RATOR_MONITORING</code> schema.</p>
  
  <pre><code>GRANT REFERENCES ON "RATOR_MONITORING_CONFIGURATION"."SMSC_GATEWAY" TO "RATOR_MONITORING";  
  ALTER TABLE "RATOR_MONITORING"."SMSC_GATEWAY_STATUS" ADD CONSTRAINT "SMSC_GATEWAY_STATUS_FK1" FOREIGN KEY ("SMSC_GATEWAY_ID")  
     REFERENCES "RATOR_MONITORING_CONFIGURATION"."SMSC_GATEWAY" ("ID") ON DELETE CASCADE ENABLE; 
  </code></pre>
  
  <p>When i run the below query i am  getting error as :</p>
  
  <pre><code>SQL Error: ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
  </code></pre>
  
  <p>I have other sql statements as well which i want to run from <code>RATOR_MONITOR</code> schema only. This sql statement are stored in a sql file. And i am running this sql file in sql plus. So is there any way using anonymous block or any other approch where i can connect to schema <code>RATOR_MONITORING_CONFIGURATION</code> schema and grant the reference permission and again connect to rator_monitor schema and run the alter table statement and also other sql statements.</p>