Hi,
since version 18, the ServerScriptGenerator does not extract the user objects grants in Oracle any more.
See Issue 12869.
Can you fix it please!
Regards,
Jens
The include object permissions flag was not correctly been passed to the scripting process but instead false was been used. This bug was introduced in version 18. fixed with committed revision: 53788
QA can use the following scripts to create 3 users, a table for each user and object permissions to each user then use the server script generator to script the users with permissions.
CREATE USER "DB_LEFT" IDENTIFIED BY "PassWord123" GO CREATE USER "DB_MID" IDENTIFIED BY "PassWord123" GO CREATE USER "DB_RIGHT" IDENTIFIED BY "PassWord123" GO CREATE TABLE "DB_LEFT"."TBL01" ("A" NUMBER(15,5) NOT NULL, "B" VARCHAR2(250 BYTE) NULL, "C" VARCHAR2(250 BYTE) NULL, PRIMARY KEY("A")) GO CREATE TABLE "DB_MID"."TBL01" ("A" NUMBER(15,5) NOT NULL, "B" VARCHAR2(250 BYTE) NULL, "C" VARCHAR2(250 BYTE) NULL, PRIMARY KEY("A")) GO CREATE TABLE "DB_RIGHT"."TBL01" ("A" NUMBER(15,5) NOT NULL, "B" VARCHAR2(250 BYTE) NULL, "C" VARCHAR2(250 BYTE) NULL, PRIMARY KEY("A")) GO GRANT SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX, REFERENCES, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON "DB_MID"."TBL01" TO "DB_LEFT" WITH GRANT OPTION GO GRANT SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX, REFERENCES, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON "DB_MID"."TBL01" TO "DB_RIGHT" WITH GRANT OPTION GO GRANT SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX, REFERENCES, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON "DB_RIGHT"."TBL01" TO "DB_MID" WITH GRANT OPTION GO GRANT SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX, REFERENCES, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON "DB_RIGHT"."TBL01" TO "DB_LEFT" WITH GRANT OPTION GO GRANT SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX, REFERENCES, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON "DB_LEFT"."TBL01" TO "DB_MID" WITH GRANT OPTION GO GRANT SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX, REFERENCES, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON "DB_LEFT"."TBL01" TO "DB_RIGHT" WITH GRANT OPTION GO
QA can use the following scripts to create 3 users, a table for each user and object permissions to each user then use the server script generator to script the users with permissions.
CREATE USER "DB_LEFT" IDENTIFIED BY "PassWord123" GO CREATE USER "DB_MID" IDENTIFIED BY "PassWord123" GO CREATE USER "DB_RIGHT" IDENTIFIED BY "PassWord123" GO CREATE TABLE "DB_LEFT"."TBL01" ("A" NUMBER(15,5) NOT NULL, "B" VARCHAR2(250 BYTE) NULL, "C" VARCHAR2(250 BYTE) NULL, PRIMARY KEY("A")) GO CREATE TABLE "DB_MID"."TBL01" ("A" NUMBER(15,5) NOT NULL, "B" VARCHAR2(250 BYTE) NULL, "C" VARCHAR2(250 BYTE) NULL, PRIMARY KEY("A")) GO CREATE TABLE "DB_RIGHT"."TBL01" ("A" NUMBER(15,5) NOT NULL, "B" VARCHAR2(250 BYTE) NULL, "C" VARCHAR2(250 BYTE) NULL, PRIMARY KEY("A")) GO GRANT SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX, REFERENCES, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON "DB_MID"."TBL01" TO "DB_LEFT" WITH GRANT OPTION GO GRANT SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX, REFERENCES, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON "DB_MID"."TBL01" TO "DB_RIGHT" WITH GRANT OPTION GO GRANT SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX, REFERENCES, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON "DB_RIGHT"."TBL01" TO "DB_MID" WITH GRANT OPTION GO GRANT SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX, REFERENCES, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON "DB_RIGHT"."TBL01" TO "DB_LEFT" WITH GRANT OPTION GO GRANT SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX, REFERENCES, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON "DB_LEFT"."TBL01" TO "DB_MID" WITH GRANT OPTION GO GRANT SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX, REFERENCES, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON "DB_LEFT"."TBL01" TO "DB_RIGHT" WITH GRANT OPTION GO
Verified in 18.0.6-5.
@qa: pls verify in v19 dev build as well.
Verified in 18.0.6-5.
@qa: pls verify in v19 dev build as well.
The following patch fixes this issue:
The following patch fixes this issue:
Verified the fix in both ADS v18.0.6-5 and v19.0.0-dev-11. Works fine now.
Verified the fix in both ADS v18.0.6-5 and v19.0.0-dev-11. Works fine now.
Issue #15115 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v18.0.6-5, v19.0.0-dev-11 |
No time estimate |
The include object permissions flag was not correctly been passed to the scripting process but instead false was been used. This bug was introduced in version 18. fixed with committed revision: 53788