Oracle9iAS Portal Developer Kit

remove_group_acl procedure

Contained in package wwsec_api.

Call this procedure to perform one of three possible operations:

  • If NULL or nothing is passed into the p_privilege parameter, then all privileges for the given group, object_type_name, and name are removed.

  • If a value is passed into p_privilege, the specified privilege is removed.

  • If group_id is null, the privilege is removed for all groups.

procedure remove_group_acl

(

p_object_type_name in varchar2,

p_name in varchar2,

p_group_id in number default null,

p_privilege in varchar2 default null,

p_owner in varchar2 default wwctx_api.get_product_schema

);

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 are 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_group_id

The unique identifier of a group.

Datatype: in number
Default: null

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
Default: null

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

Exceptions:

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

  • If a problem occurs for which an exception has not been defined, an UNEXPECTED_EXCEPTION is raised.

Example:

wwsec_api.remove_group_acl

(

p_object_type_name => wwsec_api.PAGE_OBJ,

p_name => '0/156',

p_group_id => 3,

p_privilege => wwsec_api.MANAGE_PRIV

);

Related topics

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