Oracle XS_DIAG
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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 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.

Related Topics
Built-in Functions
Built-in Packages
Database Security
XS_ACL
XS_ACL_INT
XS_ADMIN_INT
XS_ADMIN_UTIL
XS_ADMIN_UTIL_INT
XS_DATA_SECURITY
XS_DATA_SECURITY_UTIL
XS_DIAG_INT
XS_MTCACHE_INT
XS_NAMESPACE
XS_PRINCIPAL
XS_SECURITY_CLASS
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx