ORA-01749 - Oracle 12c vs 11g

Question

There is some difference when I execute

create view XDUAL
as select * from dual

grant select on XDUAL to USER

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

ORA-01749: you may not GRANT/REVOKE privileges to/from yourself

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

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

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.

Answer 1

The problem is related to Oracle version. The error is shown on 11.2.0.1 but after applying of 11.2.0.4 it does not exist. The issue was changed/fixed by Oracle somewhere between these versions.