Skip to content

Add with_interit_option and with_set_option fields to postgresql_grant_role resource #574

@dhermes

Description

@dhermes

I am happy to do this implementation / tests / docs, just want to make sure you are OK with these being added @cyrilgdn.

These correspond to the admin_option, inherit_option, set_option columns in pg_catalog.pg_auth_members: https://www.postgresql.org/docs/17/catalog-pg-auth-members.html

These were not added until PostgreSQL 16:

Now the syntax is:

GRANT foo TO bar WITH ADMIN FALSE, INHERIT FALSE, SET TRUE;
-- WAS: GRANT foo TO bar WITH ADMIN FALSE;

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