Subject Re: [IBO] How to set readonly flag from grant on dataset fields
Author henry FRANQUET
--- In, Helen Borrie <helebor@t...> wrote:
> At 02:51 PM 2/08/2004 +0000, you wrote:
> >Hi
> >
> >I use TIBOTable in Delphi 5 with Firebird 1.5, sometimes with
> >automatic fields definition and most of the time with permanent
> >fields (best of all would have been : automatic fields definition
> >with some permanent one !).
> I have no idea what you mean by this! :-)
thanks for your reply

I only mean that on a TIBODataset when I don't define any field,
fields are automatically defined on opening, but when I define
fields they become permanent and on opening no extra field
definition occurs. My need is using permanent fields for lookup and
calculated fields and automatically add all the other fields of the
table (as database definition may vary)

> -- snip --
> >As I would allow end user DBA to set granting on columns, I wonder
> >how to have automatic setting on field definition depending of
> >grants (first of all read-only flag set)
> and/or (because you are not using native IBO)

does native IBO take care of privilege ?

> -- snip --
> You would need to have very exact knowledge of how the privileges
were set
> since it is between "hard" and "impossible" to
> manage SQL privileges without a properly-designed scheme.

End user DBA use a application feature to set privileges.
Then I'll use rdb$user_privileges to get user's rights. End-user
have to know their right about a field as soon as it is displayed

> -- snip --
> The logic would be quite horrendous and the application overhead
at startup
> would be significant.
I already read the entire database scheme at start up to have exact
datatype of fields, domain name, default values, check values,
indexes, foreign keys and so on