Thread

1. Current User

   Jorge Maturana <ateo@labsd.inf.utfsm.cl> — 1998-11-11T23:30:59Z

   Hi,
   
   I want to have a table to manage  a register of the modifications made to
   several tables by a group of users, that table should contain the name of the
   postgres user that made the modificaction, now, How can I get the name (or
   the user id) of the current user logged in?,there are some "pg_currentuser"
   table to make a select?
   
   I would thank any help.
   
   -- 
   Jorge Maturana Ortiz
   Laboratorio de Sistemas Distribuidos - Departamento de Informatica
   Universidad Tecnica Federico Santa Maria, Valparaiso - Chile
   mailto:ateo@labsd.inf.utfsm.cl
   
   

2. Re: [SQL] Current User

   David Hartwig <daveh@insightdist.com> — 1998-11-12T21:52:26Z

   select CURRENT_USER;
    -- or --
   select usesysid from pg_user where usename = CURRENT_USER;
   
   Jorge Maturana wrote:
   
   > Hi,
   >
   > I want to have a table to manage  a register of the modifications made to
   > several tables by a group of users, that table should contain the name of the
   > postgres user that made the modificaction, now, How can I get the name (or
   > the user id) of the current user logged in?,there are some "pg_currentuser"
   > table to make a select?
   >
   > I would thank any help.
   >
   > --
   > Jorge Maturana Ortiz
   > Laboratorio de Sistemas Distribuidos - Departamento de Informatica
   > Universidad Tecnica Federico Santa Maria, Valparaiso - Chile
   > mailto:ateo@labsd.inf.utfsm.cl
   
   
   

3. Re: [SQL] Current User

   D'Arcy J.M. Cain <darcy@druid.net> — 1998-11-13T00:12:45Z

   Thus spake Jorge Maturana
   > I want to have a table to manage  a register of the modifications made to
   > several tables by a group of users, that table should contain the name of the
   > postgres user that made the modificaction, now, How can I get the name (or
   > the user id) of the current user logged in?,there are some "pg_currentuser"
   > table to make a select?
   
   Look at insert_username in contrib/spi.  Basically you create a trigger
   on insert.
   
   -- 
   D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
   http://www.druid.net/darcy/                |  and a sheep voting on
   +1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.