Re: Access Denied

[Chris Travers <..hidden..>]

On Wed, Jun 15, 2011 at 10:19 PM, Luke <..hidden..> wrote:
> Access denied when trying to save a new customer as the admin user in 1.3.

By default I don't think we give the admin user rights beyond those to
create users/manage permissions.  But to be sure....

Can you send me the result of the following query:

select rolname from pg_roles where pg_has_role('[admin_username]',
rolname, 'usage');
\
>
>
> [Thu Jun 16 05:09:19 2011] [error] [client xx.xx.140.61] DBD::Pg::st
> execute failed: ERROR:  permission denied for relation customertax,
> referer: http://devel/ledgersmb/customer.pl
> [Thu Jun 16 05:09:19 2011] [error] [client xx.xx.140.61] CONTEXT:  SQL
> statement "DELETE FROM customertax WHERE customer_id =  $1 ", referer:
> http://devel/ledgersmb/customer.pl
> [Thu Jun 16 05:09:19 2011] [error] [client xx.xx.140.61] PL/pgSQL
> function "eca__set_taxes" line 15 at SQL statement at LedgerSMB.pm line
> 743., referer: http://devel/ledgersmb/customer.pl
> [Thu Jun 16 05:09:19 2011] [error] [client xx.xx.140.61] 2011/06/16
> 05:09:19 -
> ERROR Logging SQL State 42501, error 7, string ERROR:  permission denied
> for relation customertax, referer: http://devel/ledgersmb/customer.pl
> [Thu Jun 16 05:09:19 2011] [error] [client xx.xx.140.61] CONTEXT:  SQL
> statement "DELETE FROM customertax WHERE customer_id =  $1 ", referer:
> http://devel/ledgersmb/customer.pl
> [Thu Jun 16 05:09:19 2011] [error] [client xx.xx.140.61] PL/pgSQL
> function "eca__set_taxes" line 15 at SQL statement, referer:
> http://devel/ledgersmb/customer.pl
> [Thu Jun 16 05:09:19 2011] [error] [client xx.xx.140.61] ERROR - Logging
> SQL State 42501, error 7, string ERROR:  permission denied for relation
> customertax, referer: http://devel/ledgersmb/customer.pl
> [Thu Jun 16 05:09:19 2011] [error] [client xx.xx.140.61] CONTEXT:  SQL
> statement "DELETE FROM customertax WHERE customer_id =  $1 ", referer:
> http://devel/ledgersmb/customer.pl
> [Thu Jun 16 05:09:19 2011] [error] [client xx.xx.140.61] PL/pgSQL
> function "eca__set_taxes" line 15 at SQL statement, referer:
> http://devel/ledgersmb/customer.pl
> [Thu Jun 16 05:09:19 2011] [error] [client xx.xx.140.61] Issuing
> rollback() for database handle being DESTROY'd without explicit
> disconnect() at LedgerSMB.pm line 858., referer:
> http://devel/ledgersmb/customer.pl
>
> ------------------------------------------------------------------------------
> EditLive Enterprise is the world's most technically advanced content
> authoring tool. Experience the power of Track Changes, Inline Image
> Editing and ensure content is compliant with Accessibility Checking.
> http://p.sf.net/sfu/ephox-dev2dev
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>