Re: Meanings of privileges

2011-03-24 Thread yongqiang he
ALTER TABLE statement contains a lot of operations. it can be altering table's metadata or altering table's data, or create new partitions etc. So ALTER TABLE should not all have the identical privilege control. Each alter table operation has its own name internally in hive, so they can have more f

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 wrote: > >>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

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. >>

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 on