babelfish-for-postgresql / babelfish_extensions / 11831283490

74%

BABEL_5_X_DEV: 75%

push

github

Login with mapped user should not use guest user privilege… (#3116)

* [OSS-ONLY] Login with mapped user should not use guest user privileges (#3088)

Previously, a guest users always remain member of a login even if login has a mapped user in a particular database. Due to this any database user is able to access the objects which are accessible to guest user which is undesirable.

Fixed this issue by only keeping one user member of a login at a time, which means, guest will be a member of login only if there is no mapped user to that login otherwise only that mapped user will be a member of login.

Task: BABEL-5389

Co-authored-by: Rishabh Tanwar <ritanwar@amazon.com>
Signed-off-by: Shalini Lohia <lshalini@amazon.com>

42 of 62 new or added lines in 3 files covered. (67.74%)

43062 of 58437 relevant lines covered (73.69%)

142867.77 hits per line