adm_group_api

This document contains the API documentation for the adm_group_api package.

Functions and Procedures

create_group

Creates a new user group

Signature:

procedure create_group (
  p_group_name in adm_groups.group_name%type,
  p_description in adm_groups.description%type,
  po_group_id out nocopy adm_groups.group_id%type
);

Parameters:

Name	Direction	Type	Description
p_group_name	in	adm_groups.group_name%type	The name of the group to be created
p_description	in	adm_groups.description%type	A description of the group’s purpose
po_group_id	out	nocopy adm_groups.group_id%type	The ID of the newly created group (output parameter)

---

add_user_to_group

Adds a user to a group

Signature:

procedure add_user_to_group (
  p_group_id in adm_groups.group_id%type,
  p_user_id in adm_users.user_id%type
);

Parameters:

Name	Direction	Type	Description
p_group_id	in	adm_groups.group_id%type	The ID of the group
p_user_id	in	adm_users.user_id%type	The ID of the user to add

---

remove_user_from_group

Removes a user from a group

Signature:

procedure remove_user_from_group (
  p_group_id in adm_groups.group_id%type,
  p_user_id in adm_users.user_id%type
);

Parameters:

Name	Direction	Type	Description
p_group_id	in	adm_groups.group_id%type	The ID of the group
p_user_id	in	adm_users.user_id%type	The ID of the user to remove

---