Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sql: support WITH GRANT OPTION when granting privileges #67410

Closed
rafiss opened this issue Jul 9, 2021 · 1 comment
Closed

sql: support WITH GRANT OPTION when granting privileges #67410

rafiss opened this issue Jul 9, 2021 · 1 comment
Assignees
@jackcwu
Labels
A-sql-privileges SQL privilege handling and permission checks. C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)

Comments

@rafiss
Copy link
Collaborator

rafiss commented Jul 9, 2021 •
edited
Loading

As described in the Postgres docs: https://www.postgresql.org/docs/current/sql-grant.html

If WITH GRANT OPTION is specified, the recipient of the privilege can in turn grant it to others. Without a grant option, the recipient cannot do that. Grant options cannot be granted to PUBLIC.

Epic CRDB-2587
@rafiss rafiss added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) A-sql-privileges SQL privilege handling and permission checks. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels Jul 9, 2021
@rafiss rafiss mentioned this issue Aug 26, 2021
Closed
@rafiss rafiss assigned rafiss and jackcwu and unassigned rafiss Nov 11, 2021
@rafiss rafiss mentioned this issue Dec 2, 2021
Closed
@rafiss
Copy link
Collaborator Author

rafiss commented Dec 6, 2021

#72123 closes this

and #72982 handles migrating old GRANT privileges.

@rafiss rafiss closed this as completed Dec 6, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jackcwu jackcwu

Labels
A-sql-privileges SQL privilege handling and permission checks. C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@rafiss @jackcwu