Oracle9iAS Portal Developer Kit

get_granted_group_privilege function

Contained in package wwsec_api.

Call this method to return the highest privilege that the specified group has on a specified object.

function get_granted_group_privilege

(

p_group_id in number,

p_object_type_name in varchar2,

p_name in varchar2,

p_owner in varchar2 default wwctx_api.get_product_schema

)

return varchar2;

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_group_id

A unique identifier for the group.

Datatype: in number

p_object_type_name

The name of the object type.

Example: ADMIN_OBJ, ITEM_OBJ, or another object type name.

Datatype: in varchar2

p_name

The unique identifier for the 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 the name of the highest privilege granted to the group, or null if no privileges are granted to the group for the specified object.

Exceptions:

This function raises no exceptions.

Example:

l_priv varchar2;

l_priv := wwsec_api.get_granted_group_privilege

(

p_group_id => 12,

p_object_type_name => wwsec_api.PAGE_OBJ,

p_name => '/156

);

Related topics

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