Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Granting access rights to view is broken [CORE5279] #5557

Closed
firebird-issue-importer opened this issue Jun 14, 2016 · 6 comments
Closed

Granting access rights to view is broken [CORE5279] #5557

firebird-issue-importer opened this issue Jun 14, 2016 · 6 comments

Comments

@firebird-issue-importer

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 14, 2016

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 16, 2016

Modified by: @AlexPeshkoff

Version: 4.0 Initial [ 10621 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 18, 2016

Modified by: @AlexPeshkoff

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 18, 2016

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0.1 [ 10730 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 20, 2016

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 20, 2016

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment