add_item_ils_privileges procedure

Related topics

Contained in package wwsbr_api.

Call this procedure to add item-level privileges for one or more users/groups to a single specified item.

Note: This procedure both adds and updates item level privileges on a single item. If a user or group is passed in more than one of the arrays below, the user or group is given the highest level privileges specified.

procedure add_item_ils_privileges(
p_master_item_id number,
p_caid number,
p_folder_id number,
p_itemown_user wwsbr_type.array default wwsbr_type.empty,
p_itemmanage_user wwsbr_type.array default wwsbr_type.empty,
p_itemview_user wwsbr_type.array default wwsbr_type.empty,
p_itemown_group wwsbr_type.array default wwsbr_type.empty,
p_itemmanage_group wwsbr_type.array default wwsbr_type.empty,
p_itemview_group wwsbr_type.array default wwsbr_type.empty
);

Version: Oracle Portal 3.0.9.8.4
(Not available Oracle9iAS 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

p_itemown_user

An array of user IDs to whom 'OWN' privileges are to granted.

Datatype: wwsbr_type.array default wwsbr_type.empty

p_itemmanage_user

An array of user IDs to whom 'MANAGE' privileges are to granted.

Datatype: wwsbr_type.array default wwsbr_type.empty

p_itemview_user

An array of user IDs to whom 'VIEW' privileges are to granted.

Datatype: wwsbr_type.array default wwsbr_type.empty

p_itemown_group

An array of group IDs to whom 'OWN' privileges are to granted.

Datatype: wwsbr_type.array default wwsbr_type.empty

p_itemmanage_group

An array of group IDs to whom 'MANAGE' privileges are to granted.

Datatype: wwsbr_type.array default wwsbr_type.empty

p_itemview_group

An array of group IDs to whom 'VIEW' privileges are to granted.

Datatype: wwsbr_type.array default wwsbr_type.empty

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

If some other error occurs while attempting to update an item, ITEM_UPDATE_ERROR exception is raised.

If the item is not set up to allow item level security, ILS_DISABLED_FOR_ITEM exception is raised. Use wwsbr_api.enable_ils_for_item before calling this procedure for this item.

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

Example:

wwsbr_api.add_item_ils_privileges(
p_master_item_id => 453,
p_caid => 33,
p_folder_id => 45,
p_itemown_user => l_itemown_user_array
);

Version: Oracle Portal 3.0.9.8.4 (Not available Oracle9iAS 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
p_itemown_user	An array of user IDs to whom 'OWN' privileges are to granted. Datatype: wwsbr_type.array default wwsbr_type.empty
p_itemmanage_user	An array of user IDs to whom 'MANAGE' privileges are to granted. Datatype: wwsbr_type.array default wwsbr_type.empty
p_itemview_user	An array of user IDs to whom 'VIEW' privileges are to granted. Datatype: wwsbr_type.array default wwsbr_type.empty
p_itemown_group	An array of group IDs to whom 'OWN' privileges are to granted. Datatype: wwsbr_type.array default wwsbr_type.empty
p_itemmanage_group	An array of group IDs to whom 'MANAGE' privileges are to granted. Datatype: wwsbr_type.array default wwsbr_type.empty
p_itemview_group	An array of group IDs to whom 'VIEW' privileges are to granted. Datatype: wwsbr_type.array default wwsbr_type.empty
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 item specific privileges cannot be added because a folder does not allow item level security, ILS_DISABLED exception is raised. If some other error occurs while attempting to update an item, ITEM_UPDATE_ERROR exception is raised. If the item is not set up to allow item level security, ILS_DISABLED_FOR_ITEM exception is raised. Use wwsbr_api.enable_ils_for_item before calling this procedure for this item. If the user does not have enough privileges to assign item-level privileges, NOT_ENOUGH_PRIVS exception is raised. Example: wwsbr_api.add_item_ils_privileges( p_master_item_id => 453, p_caid => 33, p_folder_id => 45, p_itemown_user => l_itemown_user_array );

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