create or replace package pkg_nkw_usr timestamp '2006-07-07:10:10:10' is ------------------------------------------------------------------ -- 2006 DataPRO Developers - m@urelio ------------------------------------------------------------------ -- Version: 2.0.2 ------------------------------------------------------------------ -- Collections, Records, Variables, Constants, Exceptions, Cursors ------------------------------------------------------------------ type rec_session is record(username dba_users.username%TYPE, session_flag varchar2(1)); type tab_session is table of rec_session index by binary_integer; gt_session tab_session; gr_prefs nkw_usr_prefs%ROWTYPE; ------------------------------------------------------------------ -- CREATE_USER ------------------------------------------------------------------ procedure create_user(fv_username in dba_users.username%TYPE, fv_password in varchar2); ------------------------------------------------------------------ -- DROP_USER ------------------------------------------------------------------ procedure drop_user(fv_username in dba_users.username%TYPE); ------------------------------------------------------------------ -- GRANT_SESSION ------------------------------------------------------------------ procedure grant_session(fv_username in dba_users.username%TYPE); ------------------------------------------------------------------ -- REVOKE_SESSION ------------------------------------------------------------------ procedure revoke_session(fv_username in dba_users.username%TYPE); ------------------------------------------------------------------ -- SET_SESSION ------------------------------------------------------------------ procedure set_session(ft_session in gt_session%TYPE); ------------------------------------------------------------------ -- SET_PASSWORD ------------------------------------------------------------------ procedure set_password(fv_username in dba_users.username%TYPE, fv_password in varchar2); ------------------------------------------------------------------ procedure set_password(fv_password in varchar2); ------------------------------------------------------------------ -- RESET_PASSWORD ------------------------------------------------------------------ procedure reset_password(fv_username in dba_users.username%TYPE); ------------------------------------------------------------------ -- SET_PREFERENCES ------------------------------------------------------------------ procedure set_preferences(fr_prefs in gr_prefs%TYPE); ------------------------------------------------------------------ -- GET_PREFERENCES ------------------------------------------------------------------ function get_preferences return gr_prefs%TYPE; end pkg_nkw_usr; / show errors