[TASK][MEDIUM] AuthZ plugin supports all SparkOperation

[pan3793]

Code of Conduct

• I agree to follow this project's Code of Conduct

Search before creating

• I have searched in the task list and found no similar tasks.

Mentor

• I have sufficient knowledge and experience of this task, and I volunteer to be the mentor of this task to guide contributors to complete the task.

Skill requirements

• Basic knowledge of Scala programming language
• Familiar with Spark Catalyst

Background and Goals

Presently, the Authorization (AuthZ) plugin exclusively offers access control for the ExecuteStatement operation. Enhancing its functionality to encompass all operations, such as GetCatalogs and GetTables.

Implementation steps

N/A

Additional context

Original reporter is @cfmcgrady

[pan3793]

@cfmcgrady this task is missing "implementation steps" before adding into 2023 Kyuubi Code Contribution Program

[phionex0571]

@pan3793 I think this issue is a little challenging for me but I really want to have a try, and I will most probably finish it in two months. can you aisgn it to me? thx.

[zxl-333]

@pan3793 I think this issue is a little challenging for me but I really want to have a try, and I will most probably finish it in two months. can you aisgn it to me? thx.

Is there any progress on this issue

[wForget]

@pan3793 I think this issue is a little challenging for me but I really want to have a try, and I will most probably finish it in two months. can you aisgn it to me? thx.

Is there any progress on this issue

It looks like there is no further progress, do you want to take it?

[wForget]

In addition, I have an idea for implementation.

Steps:

• Define RunnableCommand in Engine, like: KyuubiGetTablesCommand (keep logic of current engine)
• Replace KyuubiGetTablesCommand in Authz plugin with authz processing logic (ref: RuleReplaceShowObjectCommands)
• The logic of GetTables Operator in Engine: val plan = new KyuubiGetTablesCommand; spark.sessionState.executePlan(plan).executedPlan.executeCollect()

cc @pan3793

[zxl-333]

@pan3793 I think this issue is a little challenging for me but I really want to have a try, and I will most probably finish it in two months. can you aisgn it to me? thx.

Is there any progress on this issue

It looks like there is no further progress, do you want to take it?

ok