[odb-users] How to handle column based rights in ODB

[François]

Hi Boris,

Thank you for your answer.

My question was not precise enough because I may have to also update those
fields. Whereas some postgreSQL views (under some conditions) can be
updated, in the ODB documentation, it is written that ODB views are read
only.

I think I may need to change the design of my table and share columns into
several tables. Each table will have different read/write user rights.


2018-01-16 13:21 GMT+01:00 Boris Kolpackov <boris at codesynthesis.com>:

> Fanch Fanch <franchouze at gmail.com> writes:
>
> > I have a table in my DB that handles rights at the column
> level.Therefore,
> > for users who do not have read rights on all coumns, when querying with
> ODB
> > I get a "permission denied" error which is expected.
> >
> > So I woiuld like to perform something like
> >
> > SELECT my_col  FROM my_table .... ; instead of SELECT * FROM my_table
> ...;
> >
> > What is the best way to handle this using odb ?
>
> ODB views.
>
> Boris
>