babelfish-for-postgresql / babelfish_extensions / 14027564039

76%

BABEL_5_X_DEV: 77%

push

github

Prevent dropping of critical system views, functions, and procedures (#3480) (#3608)

This commit introduces restrictions to prevent the dropping of essential system views, functions, and procedures within the dbo schema for both TSQL and PSQL dialects:

    sp_addlinkedserver
    syspolicy_configuration
    syspolicy_system_health_state
    fn_syspolicy_is_automation_enabled

Generalized the restriction mechanism for handling all kinds of objects.

Note: Only superusers can drop these restricted objects and since this couldn't be added in jdbc test, adding the output here for more info:

-- psql
babelfish_db=# DROP VIEW msdb_dbo.syspolicy_system_health_state;
DROP VIEW

Task: JIRA-5145, JIRA-5146

Signed-off-by: Roshan Kanwar <rskanwar@amazon.com>

35 of 39 new or added lines in 2 files covered. (89.74%)

47636 of 63472 relevant lines covered (75.05%)

193193.96 hits per line