Hello,

Our Firebird version: 2.5

We are trying to set up a ROLE in our database so that it only has access to a set of views, and can only update tables through these views with triggers.

The problem is that we have a parent table (A) and a child table (B). Both have an X named column.

The ’B’ table has this X column as a computed field, calculated by a select from its parent records X column.

When we try to select from the view that uses the ’B’ table, the program throws an error that there is no permission for read/select access to TABLE ’A’.

It is certainly caused by the computed field because when we changed the calculation to another one without a select,

the program works. We did not find an option to grant select privilage for ’B’ table to ’A’ table.

We tried replacing the computed field definition to a select from the view (which the role will have permission to) that has acces to the desired field but according to the plan, it will use every table from the view, even when the main table of that view is ’A’,

and that would impact performance more than we’d like.

Is there a way to give permission for this computed field in table B to read from table ’A’?

Thanks!