heguanhui opened a new pull request, #63329:
URL: https://github.com/apache/doris/pull/63329
### What problem does this PR solve?
Issue Number: close #xxx
Problem Summary: Currently, dropping row policies for multiple roles
requires executing `DROP ROW POLICY` statement for each policy individually,
which is cumbersome when a role has many policies. This PR adds a new syntax
`DROP ROW POLICY FOR ROLE role1, role2, ...` to drop all row policies bound to
the specified roles in one statement.
### Release note
Support new syntax: `DROP ROW POLICY FOR ROLE role1, role2, ...` to drop all
row policies bound to specified roles in batch.
### Check List (For Author)
- Test
- [x] Regression test
- [x] Unit Test
- [ ] Manual test
- [ ] No need to test
- Behavior changed:
- [ ] No.
- [x] Yes. New SQL syntax `DROP ROW POLICY FOR ROLE` supported
- Does this need documentation?
- [ ] No.
- [x] Yes.
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
