VQL - setiamanlhc/Denodo GitHub Wiki

Create View

CREATE OR REPLACE VIEW dv_lk_v_vdp_queries FOLDER = '/90 operation view/vdp log' AS
    SELECT *
    FROM bv_lk_v_vdp_queries

Extract Global security Policy

desc vql global_security_policy blacklist_python_for_all

Crete Global Security Policy

# Generated with Denodo Platform 8.0 20240926.1 hotfix 20241212.

DROP GLOBAL_SECURITY_POLICY IF EXISTS <policy name> CASCADE;

CREATE GLOBAL_SECURITY_POLICY <name>
    ENABLED = FALSE
    AUDIENCE (
        ALL
        ANY ABAC ('userAgent' contains '["python"]')
    )
    ELEMENTS (
        ALL VIEWS
    )
    RESTRICTION (
        DENY 
    );
⚠️ **GitHub.com Fallback** ⚠️