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-automations opened this issue Jun 14, 2016 · 6 comments
Closed

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

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

Comments

@firebird-automations
Copy link
Collaborator

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-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

Version: 4.0 Initial [ 10621 ]

@firebird-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully

@firebird-automations
Copy link
Collaborator Author

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