Oracle | DBMS_XS

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

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);