Return-Path: Delivered-To: apmail-hadoop-common-commits-archive@www.apache.org Received: (qmail 57663 invoked from network); 14 Jan 2011 00:09:30 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 14 Jan 2011 00:09:30 -0000 Received: (qmail 55775 invoked by uid 500); 14 Jan 2011 00:09:28 -0000 Delivered-To: apmail-hadoop-common-commits-archive@hadoop.apache.org Received: (qmail 54982 invoked by uid 500); 14 Jan 2011 00:09:27 -0000 Mailing-List: contact common-commits-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: common-dev@hadoop.apache.org Delivered-To: mailing list common-commits@hadoop.apache.org Received: (qmail 54975 invoked by uid 500); 14 Jan 2011 00:09:27 -0000 Delivered-To: apmail-hadoop-core-commits@hadoop.apache.org Received: (qmail 54972 invoked by uid 99); 14 Jan 2011 00:09:26 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 14 Jan 2011 00:09:26 +0000 X-ASF-Spam-Status: No, hits=-1999.2 required=10.0 tests=ALL_TRUSTED,UPPERCASE_50_75 X-Spam-Check-By: apache.org Received: from [140.211.11.131] (HELO eos.apache.org) (140.211.11.131) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 14 Jan 2011 00:09:25 +0000 Received: from eosnew.apache.org (localhost [127.0.0.1]) by eos.apache.org (Postfix) with ESMTP id 6C8D41D7; Fri, 14 Jan 2011 00:08:57 +0000 (UTC) MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable From: Apache Wiki To: Apache Wiki Date: Fri, 14 Jan 2011 00:08:57 -0000 Message-ID: <20110114000857.35065.32416@eosnew.apache.org> Subject: =?utf-8?q?=5BHadoop_Wiki=5D_Update_of_=22Hive/AuthDev=22_by_HeYongqiang?= X-Virus-Checked: Checked by ClamAV on apache.org Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for ch= ange notification. The "Hive/AuthDev" page has been changed by HeYongqiang. http://wiki.apache.org/hadoop/Hive/AuthDev?action=3Ddiff&rev1=3D7&rev2=3D8 -------------------------------------------------- KEY `TBL_PRIVS_N49` (`TBL_ID`), KEY `TABLEPRIVILEGEINDEX` (`TBL_ID`,`PRINCIPAL_NAME`,`PRINCIPAL_TYPE`,`= TBL_PRIV`,`GRANTOR`,`GRANTOR_TYPE`), CONSTRAINT `TBL_PRIVS_FK1` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`T= BL_ID`) + ) ENGINE=3DInnoDB DEFAULT CHARSET=3Dlatin1; + = + -- + -- Table structure for table `PART_PRIVS` + -- + = + DROP TABLE IF EXISTS `PART_PRIVS`; + = + CREATE TABLE `PART_PRIVS` ( + `PART_GRANT_ID` bigint(20) NOT NULL, + `CREATE_TIME` int(11) NOT NULL, + `GRANT_OPTION` smallint(6) NOT NULL, + `GRANTOR` varchar(128) character set latin1 collate latin1_bin default = NULL, + `GRANTOR_TYPE` varchar(128) character set latin1 collate latin1_bin def= ault NULL, + `PART_ID` bigint(20) default NULL, + `PRINCIPAL_NAME` varchar(128) character set latin1 collate latin1_bin d= efault NULL, + `PRINCIPAL_TYPE` varchar(128) character set latin1 collate latin1_bin d= efault NULL, + `PART_PRIV` varchar(128) character set latin1 collate latin1_bin defaul= t NULL, + PRIMARY KEY (`PART_GRANT_ID`), + KEY `PARTPRIVILEGEINDEX` (`PART_ID`,`PRINCIPAL_NAME`,`PRINCIPAL_TYPE`,`= PART_PRIV`,`GRANTOR`,`GRANTOR_TYPE`), + KEY `PART_PRIVS_N49` (`PART_ID`), + CONSTRAINT `PART_PRIVS_FK1` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITI= ONS` (`PART_ID`) ) ENGINE=3DInnoDB DEFAULT CHARSET=3Dlatin1; = --