bowenliang123 commented on issue #5470:
URL: https://github.com/apache/kyuubi/issues/5470#issuecomment-1787392142
> hello, i want try this issue, but i'm not sure how to improve it, this
code is a createTableAsSql for paimon
>
> ```
> test("CreateTableAs") {
> withCleanTmpResources(Seq((s"$catalogV2.$namespace1.$table1", "table"),
> (s"$catalogV2.$namespace1.$table2", "table"))) {
> doAs(
> admin,
> sql(
> s"""
> |CREATE TABLE IF NOT EXISTS $catalogV2.$namespace1.$table1
> |(id int, name string, city string)
> |USING paimon
> |OPTIONS (
> | primaryKey = 'id'
> |)
> |""".stripMargin
> )
> )
> interceptContains[AccessControlException] {
> doAs(
> someone,
> sql(
> s"""
> |CREATE TABLE IF NOT EXISTS $catalogV2.$namespace1.$table2
> |USING PAIMON
> |AS
> |SELECT * FROM $catalogV2.$namespace1.$table1
> |""".stripMargin
> )
> )
> }(s"does not have [select] privilege on [$table1/id]")
> }
> }
> ```
>
> But when i try admin to execute the createTableAs Sql, the authz also will
print exception, like `user [admin] does not have [select] privilege on
[$table1/id]`
Hi, I'm not reproducing the case you mentioned. And #5590 is raised for it,
you may have a check on this.
If you still encounter this issue, please submit a dedicated issue with code
and logs showing the full test cases for positive and negative.
--
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]
