You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Create empty database and run the following script under SYSDBA:
create table test (id integer);
create table test1 (id integer);
create or alter view test_ as select * from test where id in (select id from test1);
grant select on test_ to public;
grant select on test1 to view test_;
Logout and login as different (non-admin) user.
Run the following statement:
select * from test_
Expected behavior (as it was working in FB 2.5.5) - view should return empty cursor.
In 3.0.0 it returns an error - no permission for SELECT access to TABLE TEST1
summary: Non admin user cannot open public view when view references another table, even if view is given appropriate grants to that table => Granting access rights to view is broken
environment: FB3 - only for tables referenced under 'in ()' clause
FB4 - for all tables
Submitted by: Dmitry Shapovalov (dshapovalov)
Create empty database and run the following script under SYSDBA:
create table test (id integer);
create table test1 (id integer);
create or alter view test_ as select * from test where id in (select id from test1);
grant select on test_ to public;
grant select on test1 to view test_;
Logout and login as different (non-admin) user.
Run the following statement:
select * from test_
Expected behavior (as it was working in FB 2.5.5) - view should return empty cursor.
In 3.0.0 it returns an error - no permission for SELECT access to TABLE TEST1
Commits: f6c9b11 19254ef
The text was updated successfully, but these errors were encountered: