From: | "Florian G(dot) Pflug" <fgp(at)phlo(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Strange permission problem regarding pg_settings |
Date: | 2003-12-10 17:08:41 |
Message-ID: | 81258D29-2B33-11D8-8389-0050E4A0EE4F@phlo.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On Dec 10, 2003, at 5:35 PM, Tom Lane wrote:
> "Florian G. Pflug" <fgp(at)phlo(dot)org> writes:
>> As user testuser (connected to testdb) :
>> .) update pg_settings set setting='public' where name='search_path' ;
>> this gives "pg_settings: permission denied"
> Hm. Works fine here. What do you get from
> select relacl, relacl is null from pg_class where relname =
> 'pg_settings';
testdb=> select relacl, relacl is null from pg_class where relname =
'pg_settings' ;
relacl | ?column?
--------+----------
{=r} | f
(1 row)
mfg, Florian Pflug
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2003-12-10 17:27:27 | Re: Strange permission problem regarding pg_settings |
Previous Message | Stephan Szabo | 2003-12-10 17:03:56 | Re: [NOVICE] PostgreSQL Training |
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2003-12-10 17:27:27 | Re: Strange permission problem regarding pg_settings |
Previous Message | Andrew Rawnsley | 2003-12-10 16:58:36 | Re: pljava revisited |