[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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





On Mon, Oct 26, 2009 at 12:16 PM, blck shp <..hidden..> wrote:
I thought it was trunk. git svn clone
https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk/
right? Please confirm.

I read the README, pre-processed the Roles.sql and executed. I did not
use the admin.pl. The user I created using the INSTALL which indicated
to run the command: createuser --no-superuser --createdb
--no-createrole -U postgres --pwprompt --encrypted UNAME, and then
INSERT commands to enter into various tables, not the admin.pl. The
user I created, does he need to be a member of all the groups? Will
this assign  permissions, or do I need to do something else? He is not
a member of any of the groups ie.  lsmb_ledgersmb13__account_all,
lsmb_ledgersmb13__account_create, lsmb_ledgersmb13__account_edit,
lsmb_ledgersmb13__all_gl, etc., etc.


If you did not not assign any groups and did this manually, that is your problem.

There are functions you can use to grant to all roles along with queries but I would want to know what you want first.

Best Wishes,
Chris Travers
 

I'm looking now and the admin.pl and I do not see an employee number
for the user I created (that could be a problem.)



On Mon, Oct 26, 2009 at 1:55 PM, Chris Travers <..hidden..> wrote:
>
>
> On Mon, Oct 26, 2009 at 11:41 AM, blck shp <..hidden..> wrote:
>>
>> Man, do I just have bad luck or what?
>>
>
> This is in trunk, right?
>
> Sounds like you don't have permissions set up.  Try reading
> sql/modules/README if you haven't done this first, and preprocessing/loading
> Roles.sql.  If you loaded via the admin.pl, then this is unnecessary and
> should be complete.
>
> If you have done this, you need to assign permissions to your user before
> you can proceed.
>
> 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