Oracle9iAS Portal Developer Kit

enable_ils_for_item procedure

Contained in package wwsbr_api.

Call this procedure to enable item-level privileges for an item.

The item's folder must be set up to permit item-level privileges.

Note: Using this procedure is the same as selecting 'Define Item Level Access Privileges' in the Oracle Portal UI.

procedure enable_ils_for_item(
  p_master_item_id number,
  p_caid number,
  p_folder_id number
  );

Version: Oracle Portal 3.0.9.8.4
(Not available Oracle 9iAS Portal 9.0.2)

Parameters:

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_caid number

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

Datatype: number

p_folder_id

The ID of the folder in which this 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 item specific privileges cannot be added because a folder does not allow item level security, ILS_DISABLED exception is raised.

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

Example:

wwsbr_api.enable_ils_for_item(
  p_master_item_id => 453,
  p_caid => 33,
  p_folder_id => 45
  );

Related topics

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