On Tue, Jun 16, 2009 at 10:02 AM, Jeff Kowalczyk <[email protected]> wrote:
> Can I get some background on the proper way to enable some missing
> permissions in the current trunk?
>
> After running install-mycompany.sh, log in, go to AR | Sales Invoice.
> Enter 'foo' in partnumber, press update:
Let's add a grant of select permissions to public on that table. There
should also be a role for managing translations which should be granted
insert and update permissions.
>
>
> Error!
>
> SELECT p.id, p.partnumber, p.description, p.sellprice,
> p.listprice, p.lastcost, p.unit, p.assembly, p.bin,
> p.onhand, p.notes, p.inventory_accno_id,
> p.income_accno_id, p.expense_accno_id, pg.partsgroup,
> p.partsgroup_id, p.partnumber AS sku, p.weight,
> t1.description AS translation,
> t2.description AS grouptranslation
> FROM parts p
> LEFT JOIN partsgroup pg ON (pg.id = p.partsgroup_id)
> LEFT JOIN translation t1
> ON (t1.trans_id = p.id AND t1.language_code = ?)
> LEFT JOIN translation t2
> ON (t2.trans_id = p.partsgroup_id
> AND t2.language_code = ?)
> WHERE p.obsolete = '0' AND NOT p.income_accno_id IS NULL AND
> lower(p.partnumber) LIKE '%foo%' ORDER BY 2
> ERROR: permission denied for relation translation
>
> [Tue Jun 16 12:56:19 2009] [error] [client 127.0.0.1]
> DBD::Pg::st execute failed:
> ERROR: permission denied for relation translation at
> LedgerSMB/IS.pm line 2143., referer:
>
> http://localhost/ledgersmb/is.pl?login=myuser&action=add&module=is.pl&type=invoice&;
>
>
> There are a few of this class of errors in the current trunk. I wanted to
> know what the security framework requires in lsmb_mycompany__(ROLNAME)
> terms, rather than just issuing GRANTs blindly.
>
> Thanks,
> Jeff
>
>
>
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables unlimited
> royalty-free distribution of the report engine for externally facing
> server and web deployment.
> http://p.sf.net/sfu/businessobjects
> _______________________________________________
> Ledger-smb-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
