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 <[email protected]> Authored: Sat Oct 4 01:47:37 2014 -0700 Committer: Prasad Mujumdar <[email protected]> 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);
