Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Grant privileges on Indexes

David CuevasFeb 2 2015 — edited Feb 2 2015

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



This post has been answered by Sven W. on Feb 2 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2015
Added on Feb 2 2015
6 comments
5,864 views