Thanks a lot for the response, Yongqiang! Just a thought, inline.
On Tue, Mar 22, 2011 at 7:28 PM, yongqiang he heyongqiang...@gmail.comwrote:
INDEX - my best guess is that this allows me to create/drop indexes on a
table?
Yes. It is there for this purpose.
Is it the case that if I have
Hi all,
I'm trying to understand the meaning of some of the privileges in the
system, and I'm a bit stumped on what some of them actually do.
Privileges that confuse me:
INDEX - my best guess is that this allows me to create/drop indexes on a
table? Is it the case that if I have select access
INDEX - my best guess is that this allows me to create/drop indexes on a
table?
Yes. It is there for this purpose.
Is it the case that if I have select access on a table, I can use
any index that exists on a table?
No. index is also a table now, so you need to have access to both of them.
LOCK