|
|||||||||||
|
[GENERAL] current_user changes immediately after login
From: Christian Schröder <cs(at)deriva.de>
Date: Wed Oct 31 2007 - 19:10:02 EDT
chschroe@db1:~> psql -h db2 testdb
Type: \copyright for distribution terms chschroe (1 row)
testdb=> select 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 matchReceived 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 |
||||||||||
|
|||||||||||