Re: DBD::Pg::st execute failed: ERROR: permission denied for relation...

[blck shp <..hidden..>]

> If you try to access using the normal user, you still get the same errors?

Yes. As superuser, I do not get permission errors pulling up AR=>Add
Transaction link:
http://192.168.1.1/ledgersmb13/ar.pl?login=UNAME&module=ar.pl&action=add&;.

As a non-superuser, I still get permission errors.

I also still get the errors like: "ERROR: cannot find user " from
admin.pl no matter if I'm superuser or not.

IDK what more roles to grant to this user:

Role name | Superuser | Create role | Create DB | Connections | Member of

 copcguy  |  no        | no          | yes       | no limit    |
{lsmb_ledgersmb13__contact_read,lsmb_ledgersmb13__contact_create,lsmb_ledgersmb13__contact_edit,lsmb_ledgersmb13__contact_all_rights,lsmb_ledgersmb13__batch_create,lsm
b_ledgersmb13__batch_post,lsmb_ledgersmb13__ar_transaction_create,lsmb_ledgersmb13__ar_transaction_create_voucher,lsmb_ledgersmb13__ar_invoice_create,lsmb_ledgersmb13__ar_invoice_create_voucher,lsmb_ledgersmb13__ar_transaction_list,lsmb_ledgersmb13__ar_voucher_all,lsmb_
ledgersmb13__ar_transaction_all,lsmb_ledgersmb13__sales_order_create,lsmb_ledgersmb13__sales_quotation_create,lsmb_ledgersmb13__sales_order_list,lsmb_ledgersmb13__sales_quotation_list,lsmb_ledgersmb13__ar_all,lsmb_ledgersmb13__ap_transaction_create,lsmb_ledgersmb13__ap_
transaction_create_voucher,lsmb_ledgersmb13__ap_invoice_create,lsmb_ledgersmb13__ap_invoice_create_voucher,lsmb_ledgersmb13__ap_transaction_list,lsmb_ledgersmb13__ap_all_vouchers,lsmb_ledgersmb13__ap_all_transactions,lsmb_ledgersmb13__purchase_order_create,lsmb_ledgersm
b13__rfq_create,lsmb_ledgersmb13__purchase_order_list,lsmb_ledgersmb13__rfq_list,lsmb_ledgersmb13__ap_all,lsmb_ledgersmb13__pos_enter,lsmb_ledgersmb13__close_till,lsmb_ledgersmb13__list_all_open,lsmb_ledgersmb13__pos_cashier,lsmb_ledgersmb13__pos_all,lsmb_ledgersmb13__r
econciliation_enter,lsmb_ledgersmb13__reconciliation_approve,lsmb_ledgersmb13__all_reconciliation_enter,lsmb_ledgersmb13__payment_process,lsmb_ledgersmb13__receipt_process,lsmb_ledgersmb13__cash_all,lsmb_ledgersmb13__part_create,lsmb_ledgersmb13__part_edit,lsmb_ledgersm
b13__inventory_reports,lsmb_ledgersmb13__pricegroup_create,lsmb_ledgersmb13__pricegroup_edit,lsmb_ledgersmb13__assembly_stock,lsmb_ledgersmb13__inventory_ship,lsmb_ledgersmb13__inventory_receive,lsmb_ledgersmb13__inventory_transfer,lsmb_ledgersmb13__warehouse_create,lsm
b_ledgersmb13__warehouse_edit,lsmb_ledgersmb13__inventory_all,lsmb_ledgersmb13__gl_transaction_create,lsmb_ledgersmb13__gl_voucher_create,lsmb_ledgersmb13__gl_reports,lsmb_ledgersmb13__yearend_run,lsmb_ledgersmb13__batch_list,lsmb_ledgersmb13__all_gl,lsmb_ledgersmb13__p
roject_create,lsmb_ledgersmb13__project_edit,lsmb_ledgersmb13__project_timecard_add,lsmb_ledgersmb13__project_timecard_list,lsmb_ledgersmb13__orders_generate,lsmb_ledgersmb13__project_order_generate,lsmb_ledgersmb13__orders_sales_to_purchase,lsmb_ledgersmb13__orders_pur
chase_consolidate,lsmb_ledgersmb13__orders_sales_consolidate,lsmb_ledgersmb13__orders_manage,lsmb_ledgersmb13__financial_reports,lsmb_ledgersmb13__print_jobs_list,lsmb_ledgersmb13__print_jobs,lsmb_ledgersmb13__system_settings_list,lsmb_ledgersmb13__system_settings_chang
e,lsmb_ledgersmb13__taxes_set,lsmb_ledgersmb13__account_create,lsmb_ledgersmb13__account_edit,lsmb_ledgersmb13__gifi_create,lsmb_ledgersmb13__gifi_edit,lsmb_ledgersmb13__account_all,lsmb_ledgersmb13__department_create,lsmb_ledgersmb13__department_edit,lsmb_ledgersmb13__
department_all,lsmb_ledgersmb13__business_type_create,lsmb_ledgersmb13__business_type_edit,lsmb_ledgersmb13__business_type_all,lsmb_ledgersmb13__sic_create,lsmb_ledgersmb13__sic_edit,lsmb_ledgersmb13__sic_all,lsmb_ledgersmb13__tax_form_save,lsmb_ledgersmb13__template_ed
it,lsmb_ledgersmb13__system_admin,lsmb_ledgersmb13__language_create,lsmb_ledgersmb13__language_edit,lsmb_ledgersmb13__part_translation_create,lsmb_ledgersmb13__project_translation_create,lsmb_ledgersmb13__all_manual_translation,lsmb_ledgersmb13__users_manage,lsmb_ledger
smb13__draft_edit,lsmb_ledgersmb13__voucher_delete}





On Tue, Oct 27, 2009 at 12:07 PM, Chris Travers <..hidden..> wrote:
>
>
> On Tue, Oct 27, 2009 at 9:59 AM, blck shp <..hidden..> wrote:
>>
>> $> postgres --version
>> postgres (PostgreSQL) 8.3.8
>>
>
> Hmmmmmm....  I am thinking about this.  Users should not be superuser
> because one can't enforce permissions in those cases.
>
> If you try to access using the normal user, you still get the same errors?
>
> It sounds to me like you need to grant roles.    Or maybe there is some odd
> issue with 8.3 I hadn't seen before.  I am going to try upgrading one of my
> dev instances and see what happens.  Stay tuned.
>
> Best Wishes,
> Chris Travers
>
>>
>>
>> On Tue, Oct 27, 2009 at 11:37 AM, Chris Travers <..hidden..>
>> wrote:
>> >
>> >
>> > On Tue, Oct 27, 2009 at 6:54 AM, blck shp <..hidden..> wrote:
>> >>
>> >> OK, an update...
>> >
>> > What version of PostgreSQL are you using?
>> >
>> > Best Wishes,
>> > Chris Travers
>> >
>> >
>> >
>> > ------------------------------------------------------------------------------
>> > Come build with us! The BlackBerry(R) Developer Conference in SF, CA
>> > is the only developer event you need to attend this year. Jumpstart your
>> > developing skills, take BlackBerry mobile applications to market and
>> > stay
>> > ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>> > http://p.sf.net/sfu/devconference
>> > _______________________________________________
>> > Ledger-smb-devel mailing list
>> > ..hidden..
>> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>> >
>> >
>>
>>
>> ------------------------------------------------------------------------------
>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
>> is the only developer event you need to attend this year. Jumpstart your
>> developing skills, take BlackBerry mobile applications to market and stay
>> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>> http://p.sf.net/sfu/devconference
>> _______________________________________________
>> Ledger-smb-devel mailing list
>> ..hidden..
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>