Re: Access Denied

[Luke <..hidden..>]

On Thu, 16 Jun 2011, Chris Travers wrote:

> 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....

In that case, the bug here is that it even presented the add customer 
formset.
The error should be more descriptive, although that is minor at this 
point.

> Can you send me the result of the following query:
>
> select rolname from pg_roles where pg_has_role('[admin_username]',
> rolname, 'usage');

                  rolname
--------------------------------------------
 lsmb_testco__contact_read
 lsmb_testco__contact_create
 lsmb_testco__contact_edit
 lsmb_testco__contact_all_rights
 lsmb_testco__batch_create
 lsmb_testco__batch_post
 lsmb_testco__ar_transaction_create
 lsmb_testco__ar_transaction_create_voucher
 lsmb_testco__ar_invoice_create
 lsmb_testco__ar_transaction_list
 lsmb_testco__ar_transaction_all
 lsmb_testco__sales_order_create
 lsmb_testco__sales_quotation_create
 lsmb_testco__sales_order_list
 lsmb_testco__sales_quotation_list
 lsmb_testco__ap_transaction_create
 lsmb_testco__ap_transaction_create_voucher
 lsmb_testco__ap_invoice_create
 lsmb_testco__ap_invoice_create_voucher
 lsmb_testco__ap_transaction_list
 lsmb_testco__ap_all_vouchers
 lsmb_testco__ap_all_transactions
 lsmb_testco__purchase_order_create
 lsmb_testco__rfq_create
 lsmb_testco__purchase_order_list
 lsmb_testco__rfq_list
 lsmb_testco__ap_all
 lsmb_testco__pos_enter
 lsmb_testco__close_till
 lsmb_testco__list_all_open
 lsmb_testco__pos_cashier
 lsmb_testco__pos_all
 lsmb_testco__reconciliation_enter
 lsmb_testco__reconciliation_approve
 lsmb_testco__reconciliation_all
 lsmb_testco__payment_process
 lsmb_testco__receipt_process
 lsmb_testco__cash_all
 lsmb_testco__part_create
 lsmb_testco__part_edit
 lsmb_testco__inventory_reports
 lsmb_testco__pricegroup_create
 lsmb_testco__pricegroup_edit
 lsmb_testco__assembly_stock
 lsmb_testco__inventory_ship
 lsmb_testco__inventory_receive
 lsmb_testco__inventory_transfer
 lsmb_testco__warehouse_create
 lsmb_testco__warehouse_edit
 lsmb_testco__inventory_all
 lsmb_testco__gl_transaction_create
 lsmb_testco__gl_voucher_create
 lsmb_testco__gl_reports
 lsmb_testco__yearend_run
 lsmb_testco__batch_list
 lsmb_testco__gl_all
 lsmb_testco__project_create
 lsmb_testco__project_edit
 lsmb_testco__project_timecard_add
 lsmb_testco__project_timecard_list
 lsmb_testco__orders_generate
 lsmb_testco__project_order_generate
 lsmb_testco__orders_sales_to_purchase
 lsmb_testco__orders_purchase_consolidate
 lsmb_testco__orders_sales_consolidate
 lsmb_testco__orders_manage
 lsmb_testco__financial_reports
 lsmb_testco__print_jobs_list
 lsmb_testco__print_jobs
 lsmb_testco__system_settings_list
 lsmb_testco__system_settings_change
 lsmb_testco__taxes_set
 lsmb_testco__account_create
 lsmb_testco__account_edit
 lsmb_testco__auditor
 lsmb_testco__audit_trail_maintenance
 lsmb_testco__gifi_create
 lsmb_testco__gifi_edit
 lsmb_testco__account_all
 lsmb_testco__department_create
 lsmb_testco__department_edit
 lsmb_testco__department_all
 lsmb_testco__business_type_create
 lsmb_testco__business_type_edit
 lsmb_testco__business_type_all
 lsmb_testco__sic_create
 lsmb_testco__sic_edit
 lsmb_testco__sic_all
 lsmb_testco__tax_form_save
 lsmb_testco__template_edit
 lsmb_testco__users_manage
 lsmb_testco__system_admin
 lsmb_testco__language_create
 lsmb_testco__language_edit
 lsmb_testco__part_translation_create
 lsmb_testco__project_translation_create
 lsmb_testco__manual_translation_all
 lsmb_testco__draft_edit
 lsmb_testco__voucher_delete
 admin
(100 rows)