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

Grantee of a access right is not recorded #14

Open
ehansmair opened this issue Feb 14, 2023 · 3 comments
Open

Grantee of a access right is not recorded #14

ehansmair opened this issue Feb 14, 2023 · 3 comments
Assignees

Comments

@ehansmair
Copy link

Thank you very much for pg-deps-management!

We set access rights to a admin role "xxx":

create view phpunit.aa_view as ( select a,b from phpunit.a_view union select b,a from phpunit.b_view);
grant select, insert, update, delete on phpunit.a, phpunit.a_view, phpunit.b_view, phpunit.aa_view to xxx with grant option;
set session authorization xxx;
grant select on phpunit.a_view to "Just_for_fun";
set session authorization default;

the acls are set like this:

grantee           privileges  grantor
====================================
Just_for_fun      r           xxx
xxx               a*r*w*d*    postgres
...

After deps_restore_dependencies() the rights are alle granted by postgres.

@rvkulikov rvkulikov self-assigned this Feb 15, 2023
@rvkulikov
Copy link
Owner

@ehansmair issue accepted, will fix in 3 days

rvkulikov pushed a commit that referenced this issue Feb 18, 2023
rvkulikov pushed a commit that referenced this issue Feb 18, 2023
@rvkulikov
Copy link
Owner

DDL generation is incorrect in current algo.
This could take more time to fix.

image

rvkulikov pushed a commit that referenced this issue Feb 24, 2023
@rvkulikov
Copy link
Owner

rvkulikov commented Feb 24, 2023

Okay, it is only left to resolve grant order now. Or edit grants directly without statements
image

rvkulikov pushed a commit that referenced this issue Mar 19, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants