pg_catalog permission problem
От | Chris Skaryd |
---|---|
Тема | pg_catalog permission problem |
Дата | |
Msg-id | acSdnUXOs_H5sJndRVn-tA@giganews.com обсуждение исходный текст |
Ответы |
Re: pg_catalog permission problem
|
Список | 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...
В списке pgsql-general по дате отправления: