Oracle | XS

Oracle XS_DIAG Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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.