CREATE OR REPLACE package EM_ACCESS_PAGE as


--
-- PURPOSE
--
--  To get the list of users and roles.
--
-- PARAMETERS
--
--  P_GIVEN_OBJECT_NAME_IN - Name of the user or role
--  P_OBJECT_NAME_OUT - List of users and roles
--  P_OBJECT_DESCRIPTION_IN - List of descritpion of roles and users
--
--
/*
PROCEDURE GET_USER_ROLE_LIST
(
    p_given_object_name	 	IN	VARCHAR2,
    p_object_name	     	OUT     VARCHAR2_TABLE,
    p_object_description 	OUT	VARCHAR2_TABLE
);

procedure get_access_info
(
    p_target_name       IN  	VARCHAR2,
    p_target_type       IN  	VARCHAR2,
    p_error_message     OUT 	VARCHAR2,
    p_user_name         OUT 	VARCHAR2_TABLE,
    p_user_description  OUT 	VARCHAR2_TABLE,
    p_user_privilege    OUT 	VARCHAR2_TABLE
);
procedure get_access_info_template
(
    p_target_name       IN  	VARCHAR2,
    p_target_type       IN  	VARCHAR2,
    p_error_message     OUT 	VARCHAR2,
    p_user_name         OUT 	VARCHAR2_TABLE,
    p_user_description  OUT 	VARCHAR2_TABLE,
    p_user_privilege    OUT 	VARCHAR2_TABLE
);

PROCEDURE update_privilige
(     
   p_target_name       IN  	VARCHAR2,
   p_target_type       IN       VARCHAR2,
   p_type              IN       VARCHAR2,
   p_object_name       IN       VARCHAR2_TABLE,
   p_object_priv       IN 	VARCHAR2_TABLE	    
);
*/
end EM_ACCESS_PAGE;
/