ORA-01749 - Oracle 12c vs 11g
<p>There is some difference when I execute </p>

<pre><code>create view XDUAL
as select * from dual

grant select on XDUAL to USER
</code></pre>

<p>between Oracle 12c and 11g (replace USER with your current user). It gives me an error only on 11g:</p>

<pre><code>ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
</code></pre>

<p>But it works fine on 12c. It's possible to GRANT privileges to myself on my own objects. </p>

<p>The definition of users are the same. They have exactly the same content of <code>USER_ROLE_PRIVS</code> and <code>USER_SYS_PRIVS.</code> 
Do you know what the reason is? Is it possible to disable somehow the error on 11g?</p>

<p>BTW. Do not point me that it doesn't make sense to give privileges to myself for my object. I know that and it's not a solution. I have some package that works fine on 12c and doesn't work on 11g and I cannot modify it for some reasons.</p>