remove_user_acl procedure

Related topics

Contained in package wwsec_api.

Call this procedure to do either of two operations:

If no value for p_privilege is found, the specified user is removed from the Access Control List table.

If a value for p_privilege is found, only the specified privilege for the specified user is removed from the Access Control List.

procedure remove_user_acl

(

p_object_type_name in varchar2,

p_name in varchar2,

p_person_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 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_person_id

The unique identifier of a person.

Note: If p_person_id is null, this procedure removes the privilege for all persons.

Datatype: in number
Default: null

p_privilege

The name of the privilege for the specified user.

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

Notes:

If a null value is passed into the p_privilege parameter, this procedure removes all the privileges of the object_type_name.

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

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.

Example:

wwsec_api.remove_user_acl

(

p_object_type_name => wwsec_api.GROUP_OBJ,

p_name => '0/156',

p_person_id => 3,

p_privilege => wwsec_api.MANAGE_PRIV

);

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_person_id	The unique identifier of a person. Note: If p_person_id is null, this procedure removes the privilege for all persons. Datatype: in number Default: null
p_privilege	The name of the privilege for the specified user. These names are specified with privilege name constants of the wwsec_api package. Notes: If a null value is passed into the p_privilege parameter, this procedure removes all the privileges of the object_type_name. If a value is passed into p_privilege, only the specified privilege is removed. 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. Example: wwsec_api.remove_user_acl ( p_object_type_name => wwsec_api.GROUP_OBJ, p_name => '0/156', p_person_id => 3, p_privilege => wwsec_api.MANAGE_PRIV );

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