From: | Chris Skaryd <CSkaryd(at)TheOPALGroup(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_catalog permission problem |
Date: | 2004-01-13 17:39:47 |
Message-ID: | acSdnUXOs_H5sJndRVn-tA@giganews.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm using Postgres 7.4. I have a database called tracking and user called
test5. From the Red Hat command line test5 can psql tracking and run:
SELECT * FROM Customers;
Not surprisingly, a list of customers is shown.
I have a Visual Basic application is accessing the same database. The same
user can open a connection to the same database. When the same query is run
the following error is thrown from Postgres:
permission denied for schema pg_catalog
With the connection to the database still open, I've run the foloowing query:
SHOW search_path;
And the following error message is returned:
permission denied for relation pg_type
Setting this user to usesuper=True in the pg_shadow table enables everything
to work correctly. But I obviously don't want to do that.
I've also tried:
GRANT ALL ON SCHEMA pg_catalog TO test5;
and
GRANT ALL ON SCHEMA pg_catalog TO PUBLIC;
and that doesn't seem to work.
Any ideas on where my permissions problem is? Is this something I missed in
the Postgres install? Could the Postgres process be running under an
inccorect user id?
I'd appreciate any help. Thanks...
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Ochs | 2004-01-13 17:46:45 | Re: sql insert function |
Previous Message | scott.marlowe | 2004-01-13 17:34:14 | Re: Any real known bugs about wrong selects? |