You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sentry.apache.org by sr...@apache.org on 2014/09/25 04:17:56 UTC
git commit: SENTRY-468: Rename the oracle and postgre upgrade scripts
to ..sql format ( Committing missing files)
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 <sr...@clouera.com>
Authored: Wed Sep 24 19:16:33 2014 -0700
Committer: Sravya Tirukkovalur <sr...@clouera.com>
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