Skip to content

sql: deprecate GRANT privilege#74210

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
jackcwu:deprecate_grant_new
Dec 23, 2021
Merged

sql: deprecate GRANT privilege#74210
craig[bot] merged 1 commit intocockroachdb:masterfrom
jackcwu:deprecate_grant_new

Conversation

@jackcwu
Copy link
Copy Markdown
Contributor

@jackcwu jackcwu commented Dec 22, 2021

Resolves #73065

Release note (sql change): We will be deprecating the GRANT privilege in 22.1
before eventually removing it in 22.2 in favor of grant options. To promote
backwards compatibility for users with code still using GRANT, we will give
grant options on every privilege a user has when they are granted GRANT and
remove all their grant options when GRANT is revoked, in addition to the
existing grant option behavior.

@jackcwu jackcwu requested a review from a team December 22, 2021 17:41
@blathers-crl
Copy link
Copy Markdown

blathers-crl bot commented Dec 22, 2021

Thank you for contributing to CockroachDB. Please ensure you have followed the guidelines for creating a PR.

My owl senses detect your PR is good for review. Please keep an eye out for any test failures in CI.

I was unable to automatically find a reviewer. You can try CCing one of the following members:

  • A person you worked with closely on this PR.
  • The person who created the ticket, or a CRDB organization member involved with the ticket (author, commenter, etc.).
  • Join our community slack channel and ask on #contributors.
  • Try find someone else from here.

🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.

@blathers-crl blathers-crl bot added O-community Originated from the community X-blathers-untriaged blathers was unable to find an owner labels Dec 22, 2021
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

@jackcwu jackcwu requested review from a team and rafiss December 22, 2021 18:43
@jackcwu jackcwu force-pushed the deprecate_grant_new branch from 710003c to aabde57 Compare December 23, 2021 01:25
@jackcwu jackcwu requested review from a team and msbutler and removed request for a team December 23, 2021 01:25
Release note (sql change): We will be deprecating the GRANT privilege in 22.1
before eventually removing it in 22.2 in favor of grant options. To promote
backwards compatibility for users with code still using GRANT, we will give
grant options on every privilege a user has when they are granted GRANT and
remove all their grant options when GRANT is revoked, in addition to the
existing grant option behavior.
@jackcwu jackcwu force-pushed the deprecate_grant_new branch from aabde57 to 4c72570 Compare December 23, 2021 17:01
@rafiss rafiss removed O-community Originated from the community X-blathers-untriaged blathers was unable to find an owner labels Dec 23, 2021
@rafiss rafiss removed the request for review from msbutler December 23, 2021 17:15
Copy link
Copy Markdown
Collaborator

@rafiss rafiss left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

lgtm! nice test updates

Reviewed 4 of 6 files at r1, 7 of 7 files at r2, all commit messages.
Reviewable status: :shipit: complete! 0 of 0 LGTMs obtained (waiting on @jackcwu)

@jackcwu
Copy link
Copy Markdown
Contributor Author

jackcwu commented Dec 23, 2021

tftr!

bors r+

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Dec 23, 2021

Build succeeded:

@craig craig bot merged commit 8e22c25 into cockroachdb:master Dec 23, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

sql: deprecate "GRANT" privilege

3 participants