babelfish-for-postgresql / babelfish_extensions / 11954537654

78%

BABEL_6_X_DEV: 78%

push

github

Support adding users to T-SQL db_owner database role (#72) (#3140)

This commit adds support to alter the db_owner role and add/drop users from it.

Whenever a new user, say u1, is added to db_owner role, we will internally
create a new role u1_obj which will be owner of all the objects of u1. By doing
so, we are able to work around the cyclic dependency of role membership in
postgres. If u1 creates new objects, using the pre-existing post object creation
hook, we will reassign ownership of u1's objects to u1_obj.

Similarly, if u1 is dropped from db_owner role, we will drop the u1_obj role and
reassign ownership u1's objects from u1_obj role back to u1.

Task: BABEL-4899
Signed-off-by: Sharu Goel <goelshar@amazon.com>

285 of 300 new or added lines in 8 files covered. (95.0%)

46024 of 61650 relevant lines covered (74.65%)

158132.17 hits per line