sentry-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pras...@apache.org
Subject [2/2] git commit: SENTRY-489: Sentry DB upgrade fails on Oracle with ORA-00905: missing keyword (Prasad Mujumdar, reviewed by Lenni Kuff)
Date Sat, 04 Oct 2014 08:47:54 GMT
SENTRY-489: Sentry DB upgrade fails on Oracle with ORA-00905: missing keyword (Prasad Mujumdar,
reviewed by Lenni Kuff)


Project: http://git-wip-us.apache.org/repos/asf/incubator-sentry/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-sentry/commit/af221d15
Tree: http://git-wip-us.apache.org/repos/asf/incubator-sentry/tree/af221d15
Diff: http://git-wip-us.apache.org/repos/asf/incubator-sentry/diff/af221d15

Branch: refs/heads/master
Commit: af221d152a224481a86d79d866f1b35e50ba09c0
Parents: 561b3c8
Author: Prasad Mujumdar <prasadm@cloudera.com>
Authored: Sat Oct 4 01:47:37 2014 -0700
Committer: Prasad Mujumdar <prasadm@cloudera.com>
Committed: Sat Oct 4 01:47:37 2014 -0700

----------------------------------------------------------------------
 .../src/main/resources/002-SENTRY-339.oracle.sql          |  2 +-
 .../src/main/resources/003-SENTRY-380.oracle.sql          | 10 +++++-----
 2 files changed, 6 insertions(+), 6 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-sentry/blob/af221d15/sentry-provider/sentry-provider-db/src/main/resources/002-SENTRY-339.oracle.sql
----------------------------------------------------------------------
diff --git a/sentry-provider/sentry-provider-db/src/main/resources/002-SENTRY-339.oracle.sql
b/sentry-provider/sentry-provider-db/src/main/resources/002-SENTRY-339.oracle.sql
index 67e971a..f64f690 100644
--- a/sentry-provider/sentry-provider-db/src/main/resources/002-SENTRY-339.oracle.sql
+++ b/sentry-provider/sentry-provider-db/src/main/resources/002-SENTRY-339.oracle.sql
@@ -1,4 +1,4 @@
 -- SENTRY-339
 ALTER TABLE SENTRY_DB_PRIVILEGE DROP CONSTRAINT "SENTRY_DB_PRIV_PRIV_NAME_UNIQ";
 ALTER TABLE SENTRY_DB_PRIVILEGE ADD CONSTRAINT "SENTRY_DB_PRIV_PRIV_NAME_UNIQ" UNIQUE ("SERVER_NAME","DB_NAME","TABLE_NAME","URI","ACTION","WITH_GRANT_OPTION");
-ALTER TABLE SENTRY_DB_PRIVILEGE DROP PRIVILEGE_NAME;
+ALTER TABLE SENTRY_DB_PRIVILEGE DROP COLUMN PRIVILEGE_NAME;

http://git-wip-us.apache.org/repos/asf/incubator-sentry/blob/af221d15/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
index e35bb58..d07d20e 100644
--- 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
@@ -1,7 +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_DB_PRIVILEGE" DROP COLUMN "GRANTOR_PRINCIPAL";
+ALTER TABLE "SENTRY_ROLE" DROP COLUMN "GRANTOR_PRINCIPAL";
+ALTER TABLE "SENTRY_GROUP" DROP COLUMN "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
+ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" ADD "GRANTOR_PRINCIPAL" VARCHAR2(128);
+ALTER TABLE "SENTRY_ROLE_GROUP_MAP" ADD "GRANTOR_PRINCIPAL" VARCHAR2(128);


Mime
View raw message