Oracle | DBMS_XS

Oracle DBMS_XS_SYSTEM 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

AUTHID CURRENT_USER

Dependencies

DBMS_XS_SYSTEM_FFI

Documented No

First Available 12.1

Security Model Owned by SYS with no privileges granted

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

Subprograms

BLOCK_PRINCIPAL_CHANGES	CHECK_XSPROVISION	SET_XS_ACL_RESULT_SIZE
CHECK_XSCALLBACK

BLOCK_PRINCIPAL_CHANGES

Undocumented dbms_xs_system.block_principal_changes(bpc IN BOOLEAN);

exec dbms_xs_system.block_principal_changes(FALSE);

      BEGIN dbms_xs_system.block_principal_changes(FALSE); END;

      *

      ERROR at line 1:

      ORA-06521: PL/SQL: Error mapping function

      ORA-06512: at "SYS.DBMS_XS_SYSTEM_FFI", line 3

      ORA-06512: at "SYS.DBMS_XS_SYSTEM", line 5

      ORA-06512: at line 1

CHECK_XSCALLBACK

Undocumented dbms_xs_system.check_xsCallback RETURN BOOLEAN;

BEGIN

        IF dbms_xs_system.check_xsCallback THEN

          dbms_output.put_line('TRUE');

        ELSE

          dbms_output.put_line('FALSE');

        END IF;

      END;

      /

CHECK_XSPROVISION

Undocumented dbms_xs_system.check_xsProvision RETURN BOOLEAN;

BEGIN

        IF dbms_xs_system.check_xsProvision THEN

          dbms_output.put_line('TRUE');

        ELSE

          dbms_output.put_line('FALSE');

        END IF;

      END;

      /

SET_XS_ACL_RESULT_SIZE

Undocumented dbms_xs_system.set_xs_acl_result_size(numacl IN PLS_INTEGER);

exec dbms_xs_system.set_xs_acl_result_size(3);