[GENERAL] pg_catalog permission problem

[Chris Skaryd]

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...

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org