-- ==========================================================================
-- Name:          set_password
-- Description:   lets users set their own password
-- Installation:  must be installed by the miadmin user
-- Sample Usage:  return set_password('bozo');
-- ==========================================================================

drop function set_password(text);

create function set_password (text) returns void as
  update users set user_passwd = $1 where user_name=user;

grant usage on function set_password (text) to public;