Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

[GENERAL] current_user changes immediately after login

From: Christian Schröder <cs(at)deriva.de>
Date: Wed Oct 31 2007 - 19:10:02 EDT


Hi list,
I have a strange problem: When I connect to one of my databases, the current_user immediatly changes without any interaction from my side. This is what I do:

chschroe@db1:~> psql -h db2 testdb
Welcome to psql 8.2.5, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms

\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
testdb=> select session_user; session_user --------------

 chschroe
(1 row)

testdb=> select current_user;
 current_user



 itstaff
(1 row)

How can this happen? The consequence of this is that I cannot access the tables because the role "itstaff" has no privileges. "reset role" does not have any effect. After "set role none" the current_user is equal to the session_user and the tables are accessible again.

This problem does only occur with this database. Do you have any explanation?

Regards,

    Christian

-- 
Deriva GmbH                         Tel.: +49 551 489500-42
Financial IT and Consulting         Fax:  +49 551 489500-91
Hans-Böckler-Straße 2                  
http://www.deriva.de
D-37079 Göttingen

Deriva CA Certificate: 
http://www.deriva.de/deriva-ca.cer



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match
Received on Wed Oct 31 22:20:11 2007

This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 19:11:02 EDT

Do you need help?X

Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library