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

François franchouze at gmail.com
Wed Jan 17 04:19:50 EST 2018

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

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
> > 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

More information about the odb-users mailing list