postgresql on SuSE 7.1 with reiserfs
Hello community,
anyone experienced problems using postgresql distribution
on SuSE 7.1 with reiserfs???
I noticed the following problem:
When creating a table 'tableA' as User A I can not insert in this
table with User A. The error message is always:
ERROR: tableA: Permission denied.
The only way to insert data in the created table is to insert
with admin user postgres.
SuSE 7.1 ships with postgresql 7.0.2
Thanks in advance for your help!
Best Regards
Jos� Manuel Lorenzo L�pez
On Thu, Jun 07, 2001 at 11:37:34AM +0200, Jose Manuel Lorenzo Lopez wrote:
Hello community,
anyone experienced problems using postgresql distribution
on SuSE 7.1 with reiserfs???I noticed the following problem:
When creating a table 'tableA' as User A I can not insert in this
table with User A. The error message is always:ERROR: tableA: Permission denied.
What has reiserfs has got to do with it ?
Does User A has got insert permissions to the table. If not use GRANT.
Who is the owner of the table. If it is not User A than using GRANT your
will have to give him permission to do certain things such as insert,
update etc.
HTH
Warm Regards
--
Rajesh Fowkar
V. S. DEMPO & CO. LTD., PANAJI-GOA
Email ID : Mail@dempos.com, rfowkar@yahoo.com
Web Site : http://www.dempos.com
Import Notes
Reply to msg id not found: 20010608095754.C1448@ho.dempos.com