babelfish-for-postgresql / babelfish_extensions / 10558627540

73%

BABEL_5_X_DEV: 77%

push

github

Restrict DROP USER/ROLE from non-dbo user (#2880)

Earlier, any user was able to drop user/role, irrespective of whether that user has required privileges or not.

With this commit, Only dbo and members of db_owner will have the permission to drop user/role.  Additionally, this
restricts dropping internal database principal such as dbo and db_owner, it restricts dropping non-Babelfish roles from TDS endpoint.

Task: BABEL-5173

Authored-by: ANJU BHARTI <abanju@amazon.com>

19 of 19 new or added lines in 1 file covered. (100.0%)

42313 of 57914 relevant lines covered (73.06%)

108305.15 hits per line