Non admin user cannot open public view when view references another table, even
if view is given appropriate grants to that table
---------------------------------------------------------------------------------------------------------------------------------
Key: CORE-5279
URL: http://tracker.firebirdsql.org/browse/CORE-5279
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0.0
Reporter: Dmitry Shapovalov
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
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
