Oracle | XS_NAMESPACE

Oracle XS_NAMESPACE_INT 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 Namespace Management Internal Package

AUTHID DEFINER

Data Types -- the full DDL can be found in {ORACLE_HOME}/rdbms/admin/xsns.sql CREATE OR REPLACE NONEDITIONABLE TYPE sys.xs$ns_attribute_list AS VARRAY(1000) OF XS$NS_ATTRIBUTE; / CREATE OR REPLACE NONEDITIONABLE TYPE sys.xs$list IS VARRAY(1000) OF VARCHAR2(4000);

Dependencies

CDB_XS_NS_TEMPLATES	XS$NSTMPL	XS_ADMIN_INT
CDB_XS_NS_TEMPLATE_ATTRIBUTES	XS$NSTMPL_ATTR	XS_ADMIN_UTIL
PLITBLM	XS$NS_ATTRIBUTE	XS_NAMESPACE
XS$LIST	XS$NS_ATTRIBUTE_LIST

Documented Yes

First Available 12.1

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvtns.plb

Subprograms

ADD_ATTRIBUTES	DELETE_TEMPLATE	SET_DESCRIPTION
CREATE_TEMPLATE	REMOVE_ATTRIBUTES	SET_HANDLER

ADD_ATTRIBUTES

Add a attributes to the namespace template

Overload 1 xs_namespace.add_attributes( template IN VARCHAR2, attribute IN VARCHAR2, default_value IN VARCHAR2 := NULL, attribute_events IN PLS_INTEGER := xs_namespace.no_event);

-- demo from Oracle RAS doc

      BEGIN

        sys.xs_namespace_int.add_attributes('POAttrs', 'item_type', 'generic',  xs_namespace.update_event);

        sys.xs_namespace_int.remove_attributes('POAttrs', 'item_type');

      END;

Add a attributes to the namespace template

Overload 2 xs_namespace.add_attributes( template IN VARCHAR2, attr_list IN xs$ns_attribute_list);

TBD

CREATE_TEMPLATE

Document creation API xs_namespace.create_template( name IN VARCHAR2, attr_list IN XS$NS_ATTRIBUTE_LIST := NULL, schema IN VARCHAR2 := NULL, package IN VARCHAR2 := NULL, function IN VARCHAR2 := NULL, acl IN VARCHAR2 := 'SYS.NS_UNRESTRICTED_ACL', description IN VARCHAR2 := NULL);

-- based on demo from Oracle RAS doc

      DECLARE

       attrlist xs$ns_attribute_list;

      BEGIN

        attrlist := xs$ns_attribute_list();

        attrlist.extend(2);

        attrlist(1) := xs$ns_attribute('desc', 'general');

        attrlist(2) := xs$ns_attribute(name=>'item_no',

        attribute_events => xs_namespace.firstread_event);

      

        sys.xs_namespace_int.create_template(POAttrs, attrlist, 'SH', 'order','fulfillment', 'sys.ns_unrestricted_acl', 'Purchase Order');

      END;

      /

      

      col acl format a20

      col description format a42

      

      SELECT name, acl, description

      FROM cdb_xs_ns_templates;

      

      col attribute format a23

      col namespace format a15

      col default_value format a20

      

      SELECT *

      FROM cdb_xs_ns_template_attributes;

DELETE_TEMPLATE

Delete the namespace template xs_namespace.delete_template( template IN VARCHAR2, delete_option IN PLS_INTEGER := xs_admin_util.default_option);

exec xs_namespace_int.delete_template('POAttrs', xs_admin_util.cascade_option);

REMOVE_ATTRIBUTES

Remove all attributes to the namespace template

Overload 1 xs_namespace.remove_attributes(template IN VARCHAR2);

exec sys.xs_namespace_int.remove_attributes('POAttrs');

Remove a single attribute from the namespace template

Overload 2 xs_namespace.remove_attributes( template IN VARCHAR2, attribute IN VARCHAR2);

See ADD_ATTRIBUTES Demo Above

Remove a list of attribute from the namespace template

Overload 3 xs_namespace.remove_attributes( template IN VARCHAR2, attr_list IN XS$LIST);

TBD

SET_DESCRIPTION

Set namespace description xs_namespace.set_description( template IN VARCHAR2, description IN VARCHAR2);

exec sys.xs_namespace_int.set_description('POAttrs','Purchase Order Attributes');

SET_HANDLER

Set handler for attribute events xs_namespace.set_handler( template IN VARCHAR2, schema IN VARCHAR2, package IN VARCHAR2, function IN VARCHAR2);

exec sys.xs_namespace_int.set_handler(POAttrs', 'SH', 'orders', 'populate_po');