Hi, The user in pg_stat_activity does not change when use the 'set session authorization' command. So we couldn't track the real user. Is it a bug or a feature?
regression=# select usesysid,usename,datname from pg_stat_activity; usesysid | usename | datname ----------+----------+------------ 10 | postgres | regression (1 registro) regression=# set session authorization timbira; SET regression=> select usesysid,usename,datname from pg_stat_activity; usesysid | usename | datname ----------+----------+------------ 10 | postgres | regression (1 registro) regression=> -- Euler Taveira de Oliveira http://www.timbira.com/ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate