Access problems on temp tables

Started by Peter Eisentrautover 26 years ago2 messagesgeneral
Jump to latest
#1Peter Eisentraut
peter_e@gmx.net

A relatively unprivileged user enters:

=> create temp table foobar (foo text);
CREATE
=> insert into foobar values ('Hi');
ERROR: pg_temp.13251.2: Permission denied.

I've also tried to grant on the table, but this strikes me as weird since
I created the table and I should have all access to it anyway.

PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3

--
Peter Eisentraut
PathWay Computing, Inc.

#2Bruce Momjian
bruce@momjian.us
In reply to: Peter Eisentraut (#1)
Re: [GENERAL] Access problems on temp tables

A relatively unprivileged user enters:

=> create temp table foobar (foo text);
CREATE
=> insert into foobar values ('Hi');
ERROR: pg_temp.13251.2: Permission denied.

I've also tried to grant on the table, but this strikes me as weird since
I created the table and I should have all access to it anyway.

PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3

I just tried it here and it worked.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026