As a follow-up, the role is definitely in the fatowls_old database:


-- Role: lsmb_fatowls_old__warehouse_delete
-- DROP ROLE lsmb_fatowls_old__warehouse_delete;

CREATE ROLE lsmb_fatowls_old__warehouse_delete
  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;


Thanks.
Brian

Brian Wolf
Phone: 410.367.2958
Try out Activus Secure Payments™, our recurring payments application.
On 02/12/2013 06:54 PM, Brian Wolf wrote:
In spite of having checked "warehouse delete" checkbox on the System - Admin Users screen, we are still unable to delete a warehouse.  Attempting to delete a warehouse produces an error:

Error!


DELETE FROM warehouse
WHERE id = ?
ERROR: permission denied for relation warehouse



Thanks.
Brian

Brian Wolf
Phone: 410.367.2958
Try out Activus Secure Payments™, our recurring payments application.


------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb


_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users


------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Reply via email to