Oracle | XS

Oracle XS_DIAG Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Real Application Security Validation Utilities

AUTHID CURRENT_USER

Data Types This is the table used to store the identified inconsistencies. The table will be truncated each time when a validation routine is called by user. code The message code. description The description of the identified inconsistency. object The object where the inconsistency is identified. The wholepath that leads to the object in the validation is recorded. note Additional information that may help user to identify the inconsistency. *******************************************************************************/ CREATE GLOBAL TEMPORARY TABLE XS$VALIDATION_TABLE ( code NUMBER, description VARCHAR2(4000), object VARCHAR2(4000), note VARCHAR2(4000)) ON COMMIT PRESERVE ROWS;

Dependencies

DBMS_ASSERT	DBMS_UTILITY	XS_ADMIN_UTIL
DBMS_STANDARD	XS_ADMIN_INT	XS_DIAG_INT

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/xsdiag.sql

Subprograms

VALIDATE_ACL	VALIDATE_PRINCIPAL	VALIDATE_SECURITY_CLASS
VALIDATE_DATA_SECURITY	VALIDATE_ROLESET	VALIDATE_WORKSPACE
VALIDATE_NAMESPACE_TEMPLATE

VALIDATE_ACL

Validate an ACL xs_diag.validate_acl( name IN VARCHAR2, error_limit IN PLS_INTEGER := 1) RETURN BOOLEAN;

BEGIN

        IF xs_diag.validate_acl('ZZYZX') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

VALIDATE_DATA_SECURITY

Validate a data security policy against a specific table xs_diag.validate_data_security( policy IN VARCHAR2 := NULL, table_owner IN VARCHAR2 := NULL, table_name IN VARCHAR2 := NULL, error_limit IN PLS_INTEGER := 1) RETURN BOOLEAN;

TBD

VALIDATE_NAMESPACE_TEMPLATE

Validate a namespace template xs_diag.validate_namespace_template( name IN VARCHAR2, error_limit IN PLS_INTEGER := 1) RETURN BOOLEAN;

BEGIN

        IF xs_diag.validate_namespace_template('ZZYZX') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

VALIDATE_PRINCIPAL

Validate a principal xs_diag.validate_principal( name IN VARCHAR2, error_limit IN PLS_INTEGER := 1) RETURN BOOLEAN;

BEGIN

        IF xs_diag.validate_principal('ZZYZX') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

VALIDATE_ROLESET

Validate a roleset xs_diag.validate_roleset( name IN VARCHAR2, error_limit IN PLS_INTEGER := 1) RETURN BOOLEAN;

BEGIN

        IF xs_diag.validate_roleset('ZZYZX') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

VALIDATE_SECURITY_CLASS

Validate a security class xs_diag.validate_security_class( name IN VARCHAR2, error_limit IN PLS_INTEGER := 1) RETURN BOOLEAN;

BEGIN

        IF xs_diag.validate_security_class('ZZYZX')  THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

VALIDATE_WORKSPACE

Validate an entire workspace xs_diag.validate_workspace(error_limit IN PLS_INTEGER := 1) RETURN BOOLEAN;

BEGIN

        IF xs_diag.validate_workspace('ZZYZX') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.