adm_user_api

This document contains the API documentation for the adm_user_api package.

Functions and Procedures

add_user

Adds a new user to the system

Signature:

procedure add_user (
  p_username in adm_users.username%type,
  p_role_id in adm_users.role_id%type
);

Parameters:

Name	Direction	Type	Description
p_username	in	adm_users.username%type	The username for the new user
p_role_id	in	adm_users.role_id%type	The role ID to assign to the user

---

deactivate_user

Deactivates a user and cleans up all their shares

• Sets the user as inactive (is_active = ‘N’)
• Deletes all link shares for documents owned by the user
• Deletes all document shares (both from and to the user)
• Deletes all folder shares (both from and to the user)

Signature:

procedure deactivate_user (
  p_username in adm_users.username%type
);

Parameters:

Name	Direction	Type	Description
p_username	in	adm_users.username%type	The username to deactivate

---

activate_user

Activates a previously deactivated user

Signature:

procedure activate_user (
  p_username in adm_users.username%type
);

Parameters:

Name	Direction	Type	Description
p_username	in	adm_users.username%type	The username to activate

---