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

Re: ERROR: permission denied for relation file_links



I
On Mar 22, 2014 2:58 PM, "Max van Biezen" <..hidden..> wrote:
>
> Hi Chris,
>
> >> "access denied" in the browser.
> > This was a renamed database?
>
> It is a new DB not renamed. I can recall I had opened the same DB (not
> at the same time)  from a different LSMB instance on the same server
> though a 1.3.38 release as well. I have two instances to avoid odd
> things like this... I guess I better move that to a different server.
>
> Would that be possible to cause this?

The major causes are unusual thing relating to setup.  Basically this view is dropped and recreated on update.  Somehow you didnt get permission in the end.

Could you log in via psql to the db and \z file_links
>
>
> > For now you can:
> >
> > grant select on file_links to public;
> Indeed that fixed it. Pfew, I had just entered a lot of data. Thanks
> for the tip and quick reply.
>
> Max
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/13534_NeoTech
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users