babelfish-for-postgresql / babelfish_extensions / 13924112667

76%

BABEL_5_X_DEV: 77%

push

github

Fix for incorrect guest privileges (#3498)

Guest user should not have create privileges in guest schema and any attempt to create objects in guest schema should throw an error.

Fix:
* The function(gen_createdb_subcmds) generate subcmds for CREATE DATABASE
* In function gen_createdb_subcmds, revoked the create permissions from guest user
* Modifying this function to correctly alter guest user privileges over the guest schema.

For the MVU(mVU) we write a procedure babelfish_revoke_create_privilege_from_guest_user which will update the create privileges of guest roles in existing schemas.

Issues Resolved: BABEL-3963

Signed-off-by: Pranav Jain pranavjc@amazon.com

6 of 54 new or added lines in 1 file covered. (11.11%)

47325 of 63159 relevant lines covered (74.93%)

193796.64 hits per line