Repository: incubator-sentry Updated Branches: refs/heads/master c57e65c58 -> a8cd4fbc6
SENTRY-444: Update the schema upgrade scripts per the grantor principal changes (Sravya Tirukkovalur via Prasad Mujumdar) Project: http://git-wip-us.apache.org/repos/asf/incubator-sentry/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-sentry/commit/a8cd4fbc Tree: http://git-wip-us.apache.org/repos/asf/incubator-sentry/tree/a8cd4fbc Diff: http://git-wip-us.apache.org/repos/asf/incubator-sentry/diff/a8cd4fbc Branch: refs/heads/master Commit: a8cd4fbc65417ee28d0d8e86a6d166f78429cdba Parents: c57e65c Author: Prasad Mujumdar <[email protected]> Authored: Mon Sep 22 13:43:47 2014 -0700 Committer: Prasad Mujumdar <[email protected]> Committed: Mon Sep 22 13:43:47 2014 -0700 ---------------------------------------------------------------------- .../src/main/resources/003-SENTRY-380-derby.sql | 7 +++++++ .../src/main/resources/003-SENTRY-380-oracle.sql | 7 +++++++ .../src/main/resources/003-SENTRY-380-postgres.sql | 7 +++++++ .../src/main/resources/003-SENTRY-380.mysql.sql | 7 +++++++ .../src/main/resources/sentry-upgrade-db2-1.4.0-to-1.5.0.sql | 8 ++++++++ .../main/resources/sentry-upgrade-derby-1.4.0-to-1.5.0.sql | 2 +- .../main/resources/sentry-upgrade-mysql-1.4.0-to-1.5.0.sql | 1 + .../main/resources/sentry-upgrade-oracle-1.4.0-to-1.5.0.sql | 1 + .../resources/sentry-upgrade-postgres-1.4.0-to-1.5.0.sql | 2 ++ 9 files changed, 41 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-sentry/blob/a8cd4fbc/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380-derby.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380-derby.sql b/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380-derby.sql new file mode 100644 index 0000000..98a26ca --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380-derby.sql @@ -0,0 +1,7 @@ +-- SENTRY-380 +ALTER TABLE `SENTRY_DB_PRIVILEGE` DROP `GRANTOR_PRINCIPAL`; +ALTER TABLE `SENTRY_ROLE` DROP `GRANTOR_PRINCIPAL`; +ALTER TABLE `SENTRY_GROUP` DROP `GRANTOR_PRINCIPAL`; + +ALTER TABLE `SENTRY_ROLE_DB_PRIVILEGE_MAP` ADD `GRANTOR_PRINCIPAL` VARCHAR(128); +ALTER TABLE `SENTRY_ROLE_GROUP_MAP` ADD `GRANTOR_PRINCIPAL` VARCHAR(128); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-sentry/blob/a8cd4fbc/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380-oracle.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380-oracle.sql b/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380-oracle.sql new file mode 100644 index 0000000..e35bb58 --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380-oracle.sql @@ -0,0 +1,7 @@ +-- SENTRY-380 +ALTER TABLE `SENTRY_DB_PRIVILEGE` DROP `GRANTOR_PRINCIPAL`; +ALTER TABLE `SENTRY_ROLE` DROP `GRANTOR_PRINCIPAL`; +ALTER TABLE `SENTRY_GROUP` DROP `GRANTOR_PRINCIPAL`; + +ALTER TABLE `SENTRY_ROLE_DB_PRIVILEGE_MAP` ADD `GRANTOR_PRINCIPAL` VARCHAR2(128); +ALTER TABLE `SENTRY_ROLE_GROUP_MAP` ADD `GRANTOR_PRINCIPAL` VARCHAR2(128); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-sentry/blob/a8cd4fbc/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380-postgres.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380-postgres.sql b/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380-postgres.sql new file mode 100644 index 0000000..e6fa26b --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380-postgres.sql @@ -0,0 +1,7 @@ +-- SENTRY-380 +ALTER TABLE `SENTRY_DB_PRIVILEGE` DROP `GRANTOR_PRINCIPAL`; +ALTER TABLE `SENTRY_ROLE` DROP `GRANTOR_PRINCIPAL`; +ALTER TABLE `SENTRY_GROUP` DROP `GRANTOR_PRINCIPAL`; + +ALTER TABLE `SENTRY_ROLE_DB_PRIVILEGE_MAP` ADD `GRANTOR_PRINCIPAL` character varying(128); +ALTER TABLE `SENTRY_ROLE_GROUP_MAP` ADD `character varying(128); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-sentry/blob/a8cd4fbc/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380.mysql.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380.mysql.sql b/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380.mysql.sql new file mode 100644 index 0000000..8e0a633 --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/003-SENTRY-380.mysql.sql @@ -0,0 +1,7 @@ +-- SENTRY-380 +ALTER TABLE `SENTRY_DB_PRIVILEGE` DROP `GRANTOR_PRINCIPAL`; +ALTER TABLE `SENTRY_ROLE` DROP `GRANTOR_PRINCIPAL`; +ALTER TABLE `SENTRY_GROUP` DROP `GRANTOR_PRINCIPAL`; + +ALTER TABLE `SENTRY_ROLE_DB_PRIVILEGE_MAP` ADD `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin; +ALTER TABLE `SENTRY_ROLE_GROUP_MAP` ADD `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-sentry/blob/a8cd4fbc/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.4.0-to-1.5.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.4.0-to-1.5.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.4.0-to-1.5.0.sql index 6b0e9ce..866b22f 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.4.0-to-1.5.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.4.0-to-1.5.0.sql @@ -6,5 +6,13 @@ DROP INDEX SENTRYPRIVILEGENAME; CREATE UNIQUE INDEX SENTRYPRIVILEGENAME ON SENTRY_DB_PRIVILEGE ("SERVER_NAME",DB_NAME,"TABLE_NAME",URI,"ACTION",WITH_GRANT_OPTION); ALTER TABLE SENTRY_DB_PRIVILEGE DROP PRIVILEGE_NAME; +-- SENTRY-380 +ALTER TABLE `SENTRY_DB_PRIVILEGE` DROP `GRANTOR_PRINCIPAL`; +ALTER TABLE `SENTRY_ROLE` DROP `GRANTOR_PRINCIPAL`; +ALTER TABLE `SENTRY_GROUP` DROP `GRANTOR_PRINCIPAL`; + +ALTER TABLE `SENTRY_ROLE_DB_PRIVILEGE_MAP` ADD `GRANTOR_PRINCIPAL` VARCHAR(128); +ALTER TABLE `SENTRY_ROLE_GROUP_MAP` ADD `GRANTOR_PRINCIPAL` VARCHAR(128); + -- Version update UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.5.0', VERSION_COMMENT='Sentry release version 1.5.0' WHERE VER_ID=1; http://git-wip-us.apache.org/repos/asf/incubator-sentry/blob/a8cd4fbc/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.4.0-to-1.5.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.4.0-to-1.5.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.4.0-to-1.5.0.sql index c12a137..027f45b 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.4.0-to-1.5.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.4.0-to-1.5.0.sql @@ -1,5 +1,5 @@ RUN '001-SENTRY-327.derby.sql'; RUN '002-SENTRY-339.derby.sql'; - +RUN '003-SENTRY-380.derby.sql'; -- Version update UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.5.0', VERSION_COMMENT='Sentry release version 1.5.0' WHERE VER_ID=1; http://git-wip-us.apache.org/repos/asf/incubator-sentry/blob/a8cd4fbc/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.4.0-to-1.5.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.4.0-to-1.5.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.4.0-to-1.5.0.sql index 331f187..95247d1 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.4.0-to-1.5.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.4.0-to-1.5.0.sql @@ -1,6 +1,7 @@ SELECT 'Upgrading Sentry store schema from 1.4.0 to 1.5.0' AS ' '; SOURCE 001-SENTRY-327.mysql.sql; SOURCE 002-SENTRY-339.mysql.sql; +SOURCE 003-SENTRY-380.mysql.sql; UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.5.0', VERSION_COMMENT='Sentry release version 1.5.0' WHERE VER_ID=1; SELECT 'Finish upgrading Sentry store schema from 1.4.0 to 1.5.0' AS ' '; http://git-wip-us.apache.org/repos/asf/incubator-sentry/blob/a8cd4fbc/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.4.0-to-1.5.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.4.0-to-1.5.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.4.0-to-1.5.0.sql index dfca3aa..7a09d17 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.4.0-to-1.5.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.4.0-to-1.5.0.sql @@ -1,6 +1,7 @@ SELECT 'Upgrading Sentry store schema from 1.4.0 to 1.5.0' AS Status from dual; @001-SENTRY-327.oracle.sql @002-SENTRY-339.oracle.sql [email protected] UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.5.0', VERSION_COMMENT='Sentry release version 1.5.0' WHERE VER_ID=1; SELECT 'Finished upgrading Sentry store schema from 1.4.0 to 1.5.0' AS Status from dual; http://git-wip-us.apache.org/repos/asf/incubator-sentry/blob/a8cd4fbc/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.4.0-to-1.5.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.4.0-to-1.5.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.4.0-to-1.5.0.sql index 0b3e5fb..cc78728 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.4.0-to-1.5.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.4.0-to-1.5.0.sql @@ -1,5 +1,7 @@ SELECT 'Upgrading Sentry store schema from 1.4.0 to 1.5.0'; \i 001-SENTRY-339.postgres.sql; \i 002-SENTRY-339.postgres.sql; +\i 003-SENTRY-380.postgres.sql; + UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.5.0', VERSION_COMMENT='Sentry release version 1.5.0' WHERE VER_ID=1; SELECT 'Finished upgrading Sentry store schema from 1.4.0 to 1.5.0';
