You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Rafi Shamim (rafiss) commented:
I filed cockroachdb/cockroach#88149 to track the fix for resolving this limitation.
As far as documenting the limitation, we should say something like “{{DROP OWNED BY}} will result in an error if the user was granted a privilege using the {{GRANT SYSTEM ...}} command. To work around this, use {{SHOW SYSTEM GRANTS FOR }} and then use {{REVOKE SYSTEM ...}} for each privilege in the result."
Exalate commented:
Related PR: cockroachdb/cockroach#86619
Commit: cockroachdb/cockroach@2bd3826
Release note (sql change): DROP OWNED BY cannot be performed if the
user has synthetic privileges (in system.privileges)
Jira Issue: DOC-5465
The text was updated successfully, but these errors were encountered: