Re: DDL wiki GRANT

Well done. Thanks very much. -- Lefty On Tue, Oct 14, 2014 at 11:48 PM, Suhas Gogate wrote: > Done! Thx. That where Brett's question originated :) > > On Tue, Oct 14, 2014 at 8:45 PM, Lefty Leverenz > wrote: > >> Looks good, except that you forgot to change the GRANT syntax >>

Re: DDL wiki GRANT

Done! Thx. That where Brett's question originated :) On Tue, Oct 14, 2014 at 8:45 PM, Lefty Leverenz wrote: > Looks good, except that you forgot to change the GRANT syntax >

Re: DDL wiki GRANT

Looks good, except that you forgot to change the GRANT syntax -- it still says object_type. -- Lefty On Tue, Oct 14, 2014 at 11:41 PM, Suhas Gogat

Re: DDL wiki GRANT

Lefty/Brett, I did change the wiki.. check if it looks okay. --Suhas On Tue, Oct 14, 2014 at 7:34 PM, Lefty Leverenz wrote: > One question remains: in object_specification, are the keywords TABLE and > DATABASE optional? > > At least for TABLE I've seen queries in the test suite that omitted

Re: DDL wiki GRANT

One question remains: in object_specification, are the keywords TABLE and DATABASE optional? At least for TABLE I've seen queries in the test suite that omitted it, but that was probably for SQL standards based authorization. So I guess we should assume TABLE and DATABASE are required unless som

Re: DDL wiki GRANT

+1 -- Lefty On Tue, Oct 14, 2014 at 4:37 PM, Brett Randall wrote: > +1 > > On 15 October 2014 07:23, Suhas Gogate wrote: > > Agree w/ Brett.. so may be instead of "object_type", we can use > > "object_specification" (similar to principal specification)? > > > > GRANT > > priv_type [(column

Re: DDL wiki GRANT

+1 On 15 October 2014 07:23, Suhas Gogate wrote: > Agree w/ Brett.. so may be instead of "object_type", we can use > "object_specification" (similar to principal specification)? > > GRANT > priv_type [(column_list)] > [, priv_type [(column_list)]] ... > [ON object_specification] >

Re: DDL wiki GRANT

Agree w/ Brett.. so may be instead of "object_type", we can use "object_specification" (similar to principal specification)? GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ... [ON object_specification] TO principal_specification [, principal_specification] ...

Re: DDL wiki GRANT

I'll correct it as soon as we reach consensus. (Perhaps Thejas will chime in.) If you want to do it yourself, you can get wiki edit privilege quite easily. -- Lefty On Tue, Oct 14, 2014 at 7:

Re: DDL wiki GRANT

I agree that the use of priv_level is confusing when it is actually referring to object_name (of type TABLE or DATABASE). I don't mind the rolling-up of tbl_name or db_name into object_type, although it then makes object_type: somewhat misleading. "[ON object_type object_name]" reads well for me.

Re: DDL wiki GRANT

Hmm.. looking at the syntax priv_level does not seem to be a keyword but rather actual name of a table or database.. so why it appears like a keyword Also priv_level is confusing and rather clear syntax would should look like below... Again answer to original question from Brett, yes GRANT syntax

Re: DDL wiki GRANT

Good catch, Brett. Can we have confirmation from an expert? Also, is object_type optional? It isn't clear to me why priv_level isn't called object_name. -- Lefty On Thu, Oct 9, 2014 at 8:23 AM, Brett Randall wrote: > Hi, > > On > https://cwiki.apache.org/confluence/display/Hive/Hive+Default+

DDL wiki GRANT

Hi, On https://cwiki.apache.org/confluence/display/Hive/Hive+Default+Authorization+-+Legacy+Mode#HiveDefaultAuthorization-LegacyMode-Grant/RevokePrivileges , GRANT shows as: GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ... [ON object_type] TO principal_specific