pg_shadow permission denied for pgAdmin!!!

Поиск
Список
Период
Сортировка
От Niral Trivedi
Тема pg_shadow permission denied for pgAdmin!!!
Дата
Msg-id 328DC4EC2C9B74428D8DAED1931285BF3172D0@FLAN-EXCH01.corp.insage.com
обсуждение исходный текст
Список pgsql-admin
All,

Thank you all for your help and guidance for my previous questions regarding
ERWin problem. Now that I have started playing with pgAdmin, I am having a
new problem.

Problem 1:
---------------
When I am trying to change 'privilages' by it is giving me error 'pg_shadow
permission denied'!!!!

I know that only a 'postgres' superuser can access 'pg_shadow' file so, I am
connecting to my remote postgreSQL db using the 'postgres' superuser. But
still not working.. I have also tried to change the permission of
'pg_shadow' file itself on the UNIX box but no luck...

Anybody has any idea??

Problem 2:
----------------
I have second problem when I execute a query in pgAdmin in 'update' mode. I
am getting the result back. But if I try to Add/Edit a record it is giving
me following error:

Multiple step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.

Strange thing is, I am able to Delete a record but not Add/Edit!!!

Anybody has any idea on this, please help me..

Thanks again..

Niral


В списке pgsql-admin по дате отправления:

Предыдущее
От: snef
Дата:
Сообщение: date/time
Следующее
От: Jeff Xianfeng Liu
Дата:
Сообщение: How to back up a large object?