babelfish-for-postgresql / babelfish_extensions / 10558633325

73%

BABEL_4_X_DEV: 75%

push

github

Restrict DROP USER/ROLE from non-dbo user (#2859) (#2864) (#2881)

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%)

42327 of 57890 relevant lines covered (73.12%)

121645.4 hits per line