delete_ils_privilege procedure

Related topics

Contained in package wwsbr_api.

Call this procedure to delete item-level privileges for a single user/group on a single specified item.

procedure delete_item_ils_privileges(
p_grantee_type varchar2 default 'USER',
p_user_or_group_id number,
p_master_item_id number,
p_folder_id number,
p_caid number
);

Version: Oracle Portal 3.0.9.8.4
(Not available Oracle9iAS Portal 9.0.2)

Parameters:

p_grantee_type

Specifies if privileges are to be removed for a user or group.

Valid values are USER or GROUP.

Datatype: varchar2
Default: USER

p_user_or_group_id

The ID of the user or group.

Datatype: number

p_master_item_id

The master item ID of the item.

Note: This value can be found in WWSBR_ALL_ITEMS.MASTERID

Datatype: number

p_folder_id

The ID of the folder in which the item belongs.

Datatype: number

p_caid number

The ID of the content area in which the item belongs.

Datatype: number

Exceptions:

If the item with the given master item ID does not exist, ITEM_NOT_FOUND_ERROR exception is raised.

If an unknown error occurs, UNKNOWN_ERROR exception is raised.

If the user does not have enough privileges to remove item-level privileges, NOT_ENOUGH_PRIVS exception is raised.

Example:

declare
  l_user_id number;
begin
  l_user_id being removed
  l_user_id := 334;
wwsbr_api.add_item_ils_privileges(
  p_grantee_type => 'USER',
  p_user_or_group_id => l_user_id,
  p_master_item_id => 453,
  p_caid => 33);
end;

Version: Oracle Portal 3.0.9.8.4 (Not available Oracle9iAS Portal 9.0.2)
Parameters:
p_grantee_type	Specifies if privileges are to be removed for a user or group. Valid values are USER or GROUP. Datatype: varchar2 Default: USER
p_user_or_group_id	The ID of the user or group. Datatype: number
p_master_item_id	The master item ID of the item. Note: This value can be found in WWSBR_ALL_ITEMS.MASTERID Datatype: number
p_folder_id	The ID of the folder in which the item belongs. Datatype: number
p_caid number	The ID of the content area in which the item belongs. Datatype: number
Exceptions: If the item with the given master item ID does not exist, ITEM_NOT_FOUND_ERROR exception is raised. If an unknown error occurs, UNKNOWN_ERROR exception is raised. If the user does not have enough privileges to remove item-level privileges, NOT_ENOUGH_PRIVS exception is raised. Example: declare l_user_id number; begin l_user_id being removed l_user_id := 334; wwsbr_api.add_item_ils_privileges( p_grantee_type => 'USER', p_user_or_group_id => l_user_id, p_master_item_id => 453, p_caid => 33); end;

Related topics
Content area API package	PDK PL/SQL API Reference - Home