Oracle9iAS Portal Developer Kit

copy_privileges procedure

Contained in package wwsec_api.

Call this procedure to copy all privileges from a source object to a destination object. Access Control List (ACL) entries are created for the destination object.

The source object must exist and must be of the object type you specify. This procedure does not check to ensure that the destination object exists. The reference to the destination object is specific to the type, and the security subsystem does not access this information.

Note: The PAGE/FOLDER privilege settings "Is Public" and "Enable ILS" do not get copied.

procedure copy_privileges

(

p_object_type in varchar2,

p_object_from in varchar2,

p_object_to in varchar2,

p_owner in varchar2 default wwctx_api.get_product_schema

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_object_type

The ACL object_type name constant for the source object.

Datatype: in varchar2

p_object_from

The unique name of the source object.

Datatype: in varchar2

p_object_to

The unique name of the destination object.

Datatype: in varchar2

p_owner

The name of the schema that owns the Access Control List entry, or another name space discriminator.

Datatype: in varchar2
Default: wwctx_api.get_product_schema

Exceptions:

  • If the user who initiates the calling routine has insufficient authority to execute the routine, an ACCESS_DENIED_EXCEPTION is raised.

  • If the source object and the destination object are the same object, a VALUE_ERROR_EXCEPTION is raised.

Example:

copy_privileges

(

p_object_type => wwsec_api.PAGE_OBJ,

p_object_from => '1/1'

p_object_to => '1/399'

);

Related topics

The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio