views:

23

answers:

1

I want to know if oracle uses index when user queries data from table and that user has been granted just:
grant select on table to user

I want to know if it is needed some another grant to use index...

+4  A: 

No, there is no requirement (or ability) to grant access to an index. If the user can access the table then their queries can use any available index.

Tony Andrews