Skip to content

Support ALL object_type IN SCHEMA in GRANT / REVOKE #335

@apstndb

Description

@apstndb

https://docs.cloud.google.com/spanner/docs/reference/standard-sql/data-definition-language#grant_statement

GRANT { SELECT | INSERT | UPDATE }(column_list)
   ON TABLE table_list | ON ALL TABLES IN SCHEMA schema_name [, ...]
   TO ROLE role_list

GRANT SELECT
    ON CHANGE STREAM change_stream_list
        | ON ALL CHANGE STREAMS IN SCHEMA schema_name [, ...] }
    TO ROLE role_list

GRANT SELECT ON VIEW view_list | ON ALL VIEWS IN SCHEMA schema_name [, ...]
    TO ROLE role_list

https://docs.cloud.google.com/spanner/docs/reference/standard-sql/data-definition-language#revoke_statement
Seems undocumented, but supported.

spanner> REVOKE SELECT ON ALL TABLES IN SCHEMA sch1 FROM ROLE guest;
Query OK (16.96 sec)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    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