开发者

What to grant to user to use index of table while querying?

开发者 https://www.devze.com 2023-01-11 05:46 出处:网络
I want 开发者_如何学JAVAto 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 开发者_如何学JAVAto 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.


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消