get_granted_user_privilege function

Related topics

Contained in package wwsec_api.

Call this method to get the granted privilege that a user has on a specified object.

function get_granted_user_privilege

(

p_user_id in varchar2,

p_object_type_name in varchar2,

p_name in varchar2,

p_owner in varchar2 default wwctx_api.get_product_schema

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_user_id

A unique identifier for the user.

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:

The privilege of the highest granted privilege 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_user_privilege

(

p_user_id =>12,

p_object_type_name=>wwsec_api.QBEFORM_OBJ,

p_name=>'33',

p_owner => 'SCOTT'

);

Version: Oracle Portal 3.0.6.6.5 or later
Parameters:
p_user_id	A unique identifier for the user.
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: The privilege of the highest granted privilege 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_user_privilege ( p_user_id =>12, p_object_type_name=>wwsec_api.QBEFORM_OBJ, p_name=>'33', p_owner => 'SCOTT' );

Related topics
Security API package	PDK PL/SQL API Reference - Home