From: | Gregory Stone <guomo(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | grant not working on pg_class |
Date: | 2003-12-01 19:33:37 |
Message-ID: | 20031201193337.80627.qmail@web14010.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've got a problem where any group or user permissions to the pg_class
table aren't being registered by either psql or the JDBC driver. I issue
the following command:
GRANT ALL ON TABLE pg_class TO GROUP apps;
-OR-
GRANT ALL ON TABLE pg_class TO sculptor;
Both apps and sculptor are valid user and group names respectively. The
command executes fine and the following query produces:
paella=> SELECT relname, relacl FROM pg_class WHERE relname='pg_class';
relname | relacl
----------+----------------------------------------------------------------------------------------------
pg_class | {=r/postgres,"group apps=arwdRxt/postgres","group
dev=w/postgres",sculptor=arwdRxt/postgres}
(1 row)
Looks good right? The permissions are there as requested. But when I try
to execute a stored procedure that, with the command below, turns off the
triggers temporarily I get ERROR: permission denied for relation
pg_class.
UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" =
''layer_template'';
I'm using postgresql 7.4, on Mac OSX, and the JDBC driver that came witht
he source dist for darwin. I've checked the groups and it seems there was
a problem back in 6.4 or so but it was allegedly fixed. Any ideas?
Thanks,
Gregory
=====
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Gregory Stone | "Suppose you were an idiot, and suppose you were
guomo(at)yahoo(dot)com | a member of congress; but I repeat myself."
| - Mark Twain
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | B. van Ouwerkerk | 2003-12-01 19:44:08 | Re: PostgreSQL from a newcomers perspective |
Previous Message | Scott Ribe | 2003-12-01 19:28:48 | Re: PostgreSQL Advocacy, Thoughts and Comments |