amazon-aurora / babelfish_extensions / 11484812955

75%

main: 77%

push

github

Support db_datareader/db_datawriter (#68)

### Description
Implement database roles `db_datareader` and `db_datawriter` 

* Members of the db_datareader fixed database role can read all data from all user tables and views. User objects can exist in any schema except sys and INFORMATION_SCHEMA.
* Members of the db_datawriter fixed database role can add, delete, or change data in all user tables. In most use cases, this role is combined with db_datareader membership to allow reading the data that is to be modified.

Engine PR: https://github.com/amazon-aurora/postgresql_modified_for_babelfish/pull/98

### Issues Resolved
Task: [BABEL-3883](https://jira.rds.a2z.com/browse/BABEL-3883)
Signed-off-by: Shalini Lohia <lshalini@amazon.com>

117 of 186 new or added lines in 4 files covered. (62.9%)

45511 of 61062 relevant lines covered (74.53%)

165755.89 hits per line