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

Re: ERROR: permission denied for relation file_links



Hi,

> 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

DBname=# \z file_links
                                      Access privileges
 Schema |    Name    | Type |          Access privileges          |
Column access privileges
--------+------------+------+-------------------------------------+--------------------------
 public | file_links | view | postgres=arwdDxt/postgres          +|
        |            |      | lsmb_DBname__file_read=r/postgres    +|
        |            |      | =r/postgres
                  |


I works as normal after the "grant" change.

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