some days ago one of my costomers got ORA-01031 when granting sys object privileges to another db user.
He used an user with DBA role to do this. The same grant works in 12.1 but not in 12.2.
Some analysis later i thought it’s a bug.
The GRANT ANY OBJECT PRIVILEGE (GAOP) was implemented in Oracle 9.2 or 10.1 (doesn’t know currently). It works in 12.1 too but doesn’t work in 12.2.
I raised a service request and got the answers now. –> It’s not a bug it’s a feature 🙂
Here are the facts: