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.

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

sql: prevent users from being dropped if they have default privileges defined for #11421

Closed
jseldess opened this issue Sep 8, 2021 · 0 comments · Fixed by #11942
Closed

sql: prevent users from being dropped if they have default privileges defined for #11421

jseldess opened this issue Sep 8, 2021 · 0 comments · Fixed by #11942

Comments

@jseldess
Copy link
Contributor

jseldess commented Sep 8, 2021

PR: cockroachdb/cockroach#67950

From release notes:

If a user has a default privilege defined for, they cannot be dropped until the default privilege is removed. Example: ALTER DEFAULT PRIVILEGES FOR ROLE test1 GRANT SELECT ON TABLES TO test2;. Neither test1 nor test2 can be dropped until performing ALTER DEFAULT PRIVILEGES FOR ROLE test1 REVOKE SELECT ON TABLES FROM test2;. [#67950][#67950]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants