> 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 <[email protected]> wrote: > > > On Tue, Oct 27, 2009 at 9:59 AM, blck shp <[email protected]> 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 <[email protected]> >> wrote: >> > >> > >> > On Tue, Oct 27, 2009 at 6:54 AM, blck shp <[email protected]> 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 >> > [email protected] >> > 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 >> [email protected] >> 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
