Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The "Hive/AuthDev" page has been changed by HeYongqiang. http://wiki.apache.org/hadoop/Hive/AuthDev?action=diff&rev1=7&rev2=8 -------------------------------------------------- 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` (`TBL_ID`) + ) ENGINE=InnoDB DEFAULT CHARSET=latin1; + + -- + -- 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 default NULL, + `PART_ID` bigint(20) default NULL, + `PRINCIPAL_NAME` varchar(128) character set latin1 collate latin1_bin default NULL, + `PRINCIPAL_TYPE` varchar(128) character set latin1 collate latin1_bin default NULL, + `PART_PRIV` varchar(128) character set latin1 collate latin1_bin default 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 `PARTITIONS` (`PART_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; --
