Skip to content

v_generate_user_grant_revoke_ddl creates invalid statement. #709

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

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions