[Umbrella] Authz permanent view related issue

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)

### Search before asking

- [X] I have searched in the [issues](https://github.com/apache/kyuubi/issues) and found no similar issues.

### Describe the proposal

Fix subquery authz check related issues.

### Task list

- [x] #5417
- [x] #5472
- [x] #5475
- [x] #5503
- [x] #5780
- [x] #5793

### Are you willing to submit PR?

- [X] Yes. I would be willing to submit a PR with guidance from the Kyuubi community to improve.
- [ ] No. I cannot submit a PR at this time.

Start by reviewing the linked issues #5417, #5472, #5475, #5503, #5780, and #5793 to understand the subquery authorization checks. The task list is already fully checked, and this umbrella issue does not state any remaining change or acceptance criteria.

Written by the indexing model from the issue text.