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

Boris Kolpackov boris at codesynthesis.com
Tue Jan 16 07:21:02 EST 2018


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



More information about the odb-users mailing list