1
76%
BABEL_5_X_DEV: 77%

Ran 24 Mar 2025 05:27AM UTC

Files 115

Run time 4s

Badge

Embed ▾

Committed 24 Mar 2025 04:55AM UTC coverage: 75.05% (+0.005%) from 75.045%

Job # 14027564039.1

Build Type

push

github

Committed by

web-flow

Commit Message

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>

Run Details

47636 of 63472 relevant lines covered (75.05%)

193193.96 hits per line

babelfish-for-postgresql / babelfish_extensions / 14027564039 / 1
76%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 14027564039.1

babelfish-for-postgresql / babelfish_extensions / 14027564039 / 1 76% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 14027564039.1

babelfish-for-postgresql / babelfish_extensions / 14027564039 / 1
76%
BABEL_5_X_DEV: 77%

README BADGES
x