Re: ERROR: permission denied for relation file

On Fri, Mar 21, 2014 at 11:10 AM, Max van Biezen <..hidden..> wrote:

Hi,

Unfortunately I am not sure how I got this result. I was editing fields of parts in menu "goods & services" in LSMB 1.3.38 using postgres 9.1. I using a fresh new database so there is no old data from previous installations.

After I had logged on as a different user with less privileges I went back to my full permission account to LSMB and when I select a part from the search list in goods&services (search simply on everything) then I get "access denied" in the browser.

This was a renamed database?

What does this mean and what can I do to make this work? Any tips on how to debug further?

For now you can:

grant select on file_links to public;

for any part I select the postgres log shows:

2014-03-21 16:46:53 CET ERROR: permission denied for relation file_links
2014-03-21 16:46:53 CET CONTEXT: SQL function "file__list_links" statement 1
2014-03-21 16:46:53 CET STATEMENT: SELECT * FROM "public"."file__list_links"('45', '3')
2014-03-21 16:52:33 CET ERROR: permission denied for relation file_links
2014-03-21 16:52:33 CET CONTEXT: SQL function "file__list_links" statement 1
2014-03-21 16:52:33 CET STATEMENT: SELECT * FROM "public"."file__list_links"('42', '3')
2014-03-21 16:54:20 CET ERROR: permission denied for relation file_links
2014-03-21 16:54:20 CET CONTEXT: SQL function "file__list_links" statement 1
2014-03-21 16:54:20 CET STATEMENT: SELECT * FROM "public"."file__list_links"('16', '3')

The apache error log shows:

2014/03/21 19:03:44 - INFO - LedgerSMB::new -- setting dbh from argstr $self->{dbh}=DBI::db=HASH(0x313e918)
DBD::Pg::st execute failed: ERROR: permission denied for relation file_links
CONTEXT: SQL function "file__list_links" statement 1 at LedgerSMB.pm line 834.
2014/03/21 19:03:44 - ERROR - LedgerSMB::dberror LedgerSMB.pm (1100) -- Logging SQL State 42501, error 7, string ERROR: permission denied for relation file_links
CONTEXT: SQL function "file__list_links" statement 1
Died at LedgerSMB.pm line 954.
Compilation failed in require at /usr/share/ledgersmb/ic.pl line 7.

Regards,

Max

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Best Wishes,

Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.

http://www.efficito.com/learn_more

Re: ERROR: permission denied for relation file_links