Oracle9iAS Portal Developer Kit

accessible_objects function (list of privileges)

Contained in package wwsec_api.

Call this function to get a list of accessible objects of a specified type for which a user, or a group to which the user belongs, has specified privileges.

function accessible_objects

(

p_object_type_name in varchar2,

p_privilege_array in wwsec_api.array,

p_owner in varchar2 default wwctx_api.get_product_schema

)

return array;

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_object_type_name

The name of the type of object referenced.

Note: These names can be specified with object_type_name constants. For example, ADMIN_OBJ, ITEM_OBJ, or another object type name.

Datatype: in varchar2

p_privilege_array

The list of privileges to be checked.

Note: These names are specified with privilege name constants of the wwsec_api package.

Datatype: in wwsec_api.array

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

Returns:

This function returns an array of objects of a specified type to which the user, or a group to which the user belongs, has specified privileges.

Exceptions:

If the specified object type does not exist in the site, a NO_ACCESSIBLE_OBJECT_EXCEPTION is raised.

Example:

l_return wwsec_api.array;

l_priv_array wwsec_api.array;
l_priv_array(1):= wwsec_api.MANAGE_PRIV;
l_priv_array(2):= wwsec_api.CREATE_PRIV;

l_return := wwsec_api.accessible_objects

(

p_object_type_name => wwsec_api.PAGE_OBJ,
p_privilege_array => l_priv_array

);

Related topics

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