The users management package has three procedures:

• add role that adds a role in the roles table
• add user that adds a user in the users table
• set user role that sets a role to a user

Procedure add role

Parameters:

• pi_role_name in varchar2 – name of the role

Call example:

• begin users_management.add_role('Junior Salesman'); end;

Procedure add user

Parameters:

• pi_user_name in varchar2 – name of the user
• pi_user_mail in varchar2 – mail of the user
• pi_user_login in varchar2 – login of the user

Call example:

• begin users_management.add_user('Chris', '[email protected]', 'chris'); end;

Procedure set user role

Parameters:

• pi_user_id in integer – user id
• pi_role_id in integer – role id

Call example:

• begin users_management.set_user_role(1, 1); end;