create or replace package wsgsr is -- --------------------------------------------------------------------- -- Security API functions -- These functions may be called from generated WSG applications. --------------------------------------------------------------------- -- -- Get_User: Returns user name of current user. -- function get_user return varchar2; pragma restrict_references (get_user, WNDS, WNPS); -- -- -- Get_User_Data: Returns information about a user, specified by -- p_key. This implementation accepts the key -- 'PASSWORD' only. Any other key will result in -- a null string being returned. -- -- function security_check( p_package_name in varchar2 ) return boolean; -- -- -- Add_Package_Resp: Adds a respondibility to a package, allowing users -- with that responsibility to access the application. -- This is called from the generated application -- installation script if a value is supplied for -- preference SECRES. -- procedure add_package_resp( p_package_name in varchar2 , p_responsibility in varchar2 ); -- -------------------------------------------------------------------------- -- Implementation specific functions -- These functions are used only by this implementation of the -- security package. -------------------------------------------------------------------------- -- -- Show_Welcome_Form: Renders welcome form. This form allows existing users -- to log on, and new users to register their details. -- procedure show_welcome_form( p_embedded in boolean default false , p_username in varchar2 default null , p_password in varchar2 default null , p_confirm in varchar2 default null , p_title in varchar2 default null , p_name1 in varchar2 default null , p_name2 in varchar2 default null , p_sex in varchar2 default null , p_email in varchar2 default null , p_address1 in varchar2 default null , p_address2 in varchar2 default null , p_address3 in varchar2 default null , p_address4 in varchar2 default null , p_postcode in varchar2 default null , p_telephone in varchar2 default null , p_urllink in varchar2 default null ); -- -- -- Process_Logon: Accepts submitted logon form and logs user on, or stores -- details about new user and logs them on. -- procedure process_logon( p_username in varchar2 , p_password in varchar2 , p_confirm in varchar2 , p_title in varchar2 , p_name1 in varchar2 , p_name2 in varchar2 , p_sex in varchar2 , p_email in varchar2 , p_address1 in varchar2 , p_address2 in varchar2 , p_address3 in varchar2 , p_address4 in varchar2 , p_postcode in varchar2 , p_telephone in varchar2 , p_urllink in varchar2 ); -- -- -- Logoff: Removes the current user's session, logging them off. Outputs -- HTML message when complete. -- procedure logoff; -- -- end wsgsr; /