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

v_generate_user_grant_revoke_ddl creates invalid statement. #709

Open
Lalit7523 opened this issue Dec 15, 2023 · 0 comments
Open

v_generate_user_grant_revoke_ddl creates invalid statement. #709

Lalit7523 opened this issue Dec 15, 2023 · 0 comments

Comments

@Lalit7523
Copy link

The output of the v_generate_user_grant_revoke_ddl creates invalid statement because it quotes the object.

ALTER DEFAULT PRIVILEGES for user testuser in schema testschema REVOKE ALL on "tables" FROM testone;
ALTER DEFAULT PRIVILEGES for user testuser in schema testschema1 REVOKE ALL on "procedures" FROM testone;
ALTER DEFAULT PRIVILEGES for user testuser in schema testschema1 REVOKE ALL on "functions" FROM testone;

The expected output should be objects (tables,procedures,functions) without quotes as below.

ALTER DEFAULT PRIVILEGES for user testuser in schema testschema REVOKE ALL on tables FROM testone;
ALTER DEFAULT PRIVILEGES for user testuser in schema testschema1 REVOKE ALL on procedures FROM testone;
ALTER DEFAULT PRIVILEGES for user testuser in schema testschema1 REVOKE ALL on functions FROM testone;

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

1 participant