Oracle9iAS Portal Developer Kit

privilege_list function

Contained in package wwsec_api.

Call this routine to return a list of all the privileges granted on a specified object.

function privilege_list

(

p_object_type_name in varchar2

)

return privilege_array;

 

type privilege_array is table of wwsec_privilege$%rowtype index by binary_integer;

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

Returns:

This function returns an array containing all of the privileges currently granted on a specified object.

Exceptions:

This function raises no exceptions.

Example:

l_return wwsec_api.privilege_array;
l_return := wwsec_api.privilege_list
(

p_object_type_name => wwsec_api.PAGE_OBJ,
p_name => '0/156'

);

Related topics

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