set_group_acl procedure

Related topics

Contained in package wwsec_api.

Call this procedure to grant a privilege on a specified object to a specified group.

procedure set_group_acl

(

p_group_id in number,

p_object_type_name in varchar2,

p_owner in varchar2 default wwctx_api.get_product_schema,

p_name in varchar2,

p_privilege in varchar2

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_group_id

The unique identifier of a group.

Datatype: in number

p_object_type_name

The name of the type of object referenced.

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

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: default wwctx_api.get_product_schema

p_name

The unique name of the specific object.

Datatype: in varchar2

p_privilege

The name of the privilege to be granted.

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

Datatype: in varchar2

Exceptions:

If p_group_id does not exist, a GROUP_NOT_FOUND_EXCEPTION is raised.

If the user who initiates the calling routine has insufficient authority to execute the routine, an ACCESS_DENIED_EXCEPTION is raised.

Example:

wwsec_api.set_group_acl
(

p_group_id=>3,
p_object_type_name=>wwsec_api.PAGE_OBJ,
p_owner=>'PORTAL',
p_name=>'0/156',
p_privilege=>wwsec_api.MANAGE_PRIV

);

Version: Oracle Portal 3.0.6.6.5 or later
Parameters:
p_group_id	The unique identifier of a group. Datatype: in number
p_object_type_name	The name of the type of object referenced. Note: These names are specified with object_type_name constants. For example, ADMIN_OBJ, ITEM_OBJ, or another object type name. 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: default wwctx_api.get_product_schema
p_name	The unique name of the specific object. Datatype: in varchar2
p_privilege	The name of the privilege to be granted. Note: These names are specified with privilege name constants of the wwsec_api package. Datatype: in varchar2
Exceptions: If p_group_id does not exist, a GROUP_NOT_FOUND_EXCEPTION is raised. If the user who initiates the calling routine has insufficient authority to execute the routine, an ACCESS_DENIED_EXCEPTION is raised. Example: wwsec_api.set_group_acl ( p_group_id=>3, p_object_type_name=>wwsec_api.PAGE_OBJ, p_owner=>'PORTAL', p_name=>'0/156', p_privilege=>wwsec_api.MANAGE_PRIV );

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