Skip to content

v_generate_user_grant_revoke_ddl creates invalid statement. #709

Open
@Lalit7523

Description

@Lalit7523

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;

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions