babelfish-for-postgresql / babelfish_extensions / 13929187846

77%

Build Type

push

github

Committed by web-flow

Commit Message

Fix for incorrect guest privileges (#3498) (#3586)

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

Run Details

6 of 56 new or added lines in 1 file covered. (10.71%)

2 existing lines in 1 file now uncovered.

47430 of 63249 relevant lines covered (74.99%)

187806.35 hits per line