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