• Home
• it.cnr.si.sigla
• sigla-backend
• 6.6.4
• source code
• ibmutl001_trace_user_connection.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

postgresql.function.ibmutl001_trace_user_connection.sql Maven / Gradle / Ivy

-- Function: public.ibmutl001_trace_user_connection(text, timestamp without time zone, text)

-- DROP FUNCTION public.ibmutl001_trace_user_connection(text, timestamp without time zone, text);

CREATE OR REPLACE FUNCTION ibmutl001_trace_user_connection(
    auser text,
    atsnow timestamp without time zone,
    ahttpsid text)
  RETURNS void AS
$BODY$
BEGIN
  --DBMS_APPLICATION_INFO.SET_CLIENT_INFO(rpad(aUser,20,' ')|| to_char(aTSNow,'YYYY-MM-DD HH:MI:SS')||aHTTPSID);
END;


$BODY$
  LANGUAGE plpgsql STABLE SECURITY DEFINER
  COST 100;