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.
What does this mean and what can I do to make this work? Any tips on how to debug further?
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.