babelfish-for-postgresql / babelfish_extensions / 10916898294

74%

BABEL_4_X_DEV: 75%

Build Type

push

github

Committed by web-flow

Commit Message

[Fix] Database owner login is unable to view db objects in SSMS (#2925)

Currently in babelfish when we create a login (e.g. postjend_svc) and a database (e.g. test) and make postjend_svc owner of test and then connect to SSMS object explorer as login "postjend_svc" to database "test" and try to expand the "Database" field to view the objects. It does not show anything. With this change the login with be able to expand the "Database" field.

The issue arised because when the databases are expanded in SSMS, a query is being executed which contains a cross-db query. Currently, we handle cross-db queries by switching the database and current user. This cross-db query is resulting into permission denied error due to lack of permission of the current user (which is switched internally to master_guest) to insert into a table created in "test" db.

Task: BABEL-5119, BABEL-5218

Signed-off-by: P Aswini Kumar <aswinii@amazon.com>

Run Details

50 of 52 new or added lines in 5 files covered. (96.15%)

2 existing lines in 2 files now uncovered.

42768 of 58067 relevant lines covered (73.65%)

139364.37 hits per line