Oracle9iAS Portal Developer Kit

grantee_list function

Contained in package wwsec_api.

Call this routine to return a list of users who have been granted privileges on a specific object, given an object type and an object name.

function grantee_list

(

p_object_type_name in varchar2,

p_name in varchar2,

p_owner in varchar2 default wwctx_api.get_product_schema

)

return grantee_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_name

The unique name of the specific 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

Returns:

This function returns an array of grantee user IDs.

Exceptions:

This function raises no exceptions.

Example:

l_return wwsec_api.grantee_array;
l_return := wwsec_api.grantee_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