Skip to content

SQL-dump with GRANT ... WITH GRANT OPTION #6

@antonov-impulsm

Description

@antonov-impulsm

it could be situations when pg_dump temporary changes session authorization.

for example:

GRANT SELECT ON TABLE my_sch.my_view TO xxx WITH GRANT OPTION;
SET SESSION AUTHORIZATION xxx;
GRANT SELECT ON TABLE my_sch.my_view TO zzz WITH GRANT OPTION;
RESET SESSION AUTHORIZATION;

we should write rule for it, if it possible in current architecture of pg-dump-splitter.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions