UPDATE pg_catalog.pg_class as NO Superuser??
| От | Kai Behncke |
|---|---|
| Тема | UPDATE pg_catalog.pg_class as NO Superuser?? |
| Дата | |
| Msg-id | 20070913092539.303460@gmx.net обсуждение исходный текст |
| Ответы |
Re: UPDATE pg_catalog.pg_class as NO Superuser??
Re: UPDATE pg_catalog.pg_class as NO Superuser?? |
| Список | pgsql-general |
Dear list,
on my system I have multiple user.
I want that the user xy (who is no superuser) can Update a systemtable with:
UPDATE pg_catalog.pg_class SET reltriggers = 0;
With psql I already wrote:
ALTER TABLE pg_catalog.pg_class OWNER TO xy;
and
GRANT ALL PRIVILEGES ON pg_catalog.pg_class TO xy;
I check it with \dS
and see:
List of relations
Schema | Name | Type | Owner
------------+--------------------------+-------+-----------
pg_catalog | pg_aggregate | table | postgres
pg_catalog | pg_am | table | postgres
pg_catalog | pg_amop | table | postgres
pg_catalog | pg_amproc | table | postgres
pg_catalog | pg_attrdef | table | postgres
pg_catalog | pg_attribute | table | postgres
pg_catalog | pg_auth_members | table | postgres
pg_catalog | pg_authid | table | postgres
pg_catalog | pg_autovacuum | table | postgres
pg_catalog | pg_cast | table | postgres
pg_catalog | pg_class | table | xy
But always if I sent as user xy the
"UPDATE pg_catalog.pg_class SET reltriggers = 0;"-command I get:
"SQL error:
ERROR: permission denied for relation pg_class"
Why is that? MUST I be a superuser for that?
Is there any way to set that command as user xy?
Thank you very much in advance, Kai
--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer
В списке pgsql-general по дате отправления: