Good morning,
I am looking to try to manage some object security on the Oracle DB 12c, and i've come to the indexes objects.
After looking to the magical view: V$OBJECT_PRIVILEGE, i've came across the EXECUTE privilege on indexes:
select * from v$object_privilege where object_type_name = 'INDEX';
However, after creating some test indexes, i couldn't be able to set this privilege on both roles and actors, getting this error all the time:
SQL Error: ORA-04042: procedure, function, package, or package body does not exist
04042. 00000 - "procedure, function, package, or package body does not exist"
*Cause: Attempt to access a procedure, function, package, or package body
that does not exist.
*Action: Make sure the name is correct.
I am pretty sure that the name is correct on the index. So, does this privilege makes any sense? What's his purpose on this view?
Kind regards,
David