Repository: incubator-sentry Updated Branches: refs/heads/master a8f0c08ab -> 60db85bab
SENTRY-468: Rename the oracle and postgre upgrade scripts to <jira-id>.<db-vendoer>.sql format ( Committing missing files) Project: http://git-wip-us.apache.org/repos/asf/incubator-sentry/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-sentry/commit/60db85ba Tree: http://git-wip-us.apache.org/repos/asf/incubator-sentry/tree/60db85ba Diff: http://git-wip-us.apache.org/repos/asf/incubator-sentry/diff/60db85ba Branch: refs/heads/master Commit: 60db85bab7f796c716545d72ab65802247c2a9ac Parents: a8f0c08 Author: Sravya Tirukkovalur <[email protected]> Authored: Wed Sep 24 19:16:33 2014 -0700 Committer: Sravya Tirukkovalur <[email protected]> Committed: Wed Sep 24 19:16:33 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 +++++++ 3 files changed, 21 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-sentry/blob/60db85ba/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..f27b358 --- /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); http://git-wip-us.apache.org/repos/asf/incubator-sentry/blob/60db85ba/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/60db85ba/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
