Re: Meanings of privileges

2011-03-23 Thread Jonathan Natkins
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

Meanings of privileges

2011-03-22 Thread Jonathan Natkins
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

Re: Meanings of privileges

2011-03-22 Thread yongqiang he
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