[Subtask] Make user provider can be customized

### 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 subtask

Make user provider can be customized

### Parent issue

#5401

### 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 reading parent issue #5401 and tracing how the current user provider is selected in Kyuubi. Identify the provider entry points and existing tests before defining the customization boundary; done means a user provider can be configured or replaced and the relevant behavior is covered by tests.

Written by the indexing model from the issue text.