[jira] [Commented] (IOTDB-2736) Ordinary users are granted permission to DELETE_STORAGE_GROUP,but report 401

["xiaozhihong (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IOTDB-2736?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17506134#comment-17506134 ] 

xiaozhihong commented on IOTDB-2736:
------------------------------------

REVOKE_USER_PRIVILEGE:
Use the root user to grant and revoke user permissions to user01, and then after user01 enter the CLI, revoke a certain permission to a certain permission of user02, it  reported the prompt 602 that there is no such operation permission.
{code:java}
//root
GRANT USER user01 PRIVILEGES REVOKE_ROLE_PRIVILEGE on root;
//user01
IoTDB> REVOKE USER user02 PRIVILEGES SET_STORAGE_GROUP on root.ln;
Msg: 602: No permissions for this operation REVOKE_USER_PRIVILEGE;
{code}

> Ordinary users are granted permission to DELETE_STORAGE_GROUP,but report 401
> ----------------------------------------------------------------------------
>
>                 Key: IOTDB-2736
>                 URL: https://issues.apache.org/jira/browse/IOTDB-2736
>             Project: Apache IoTDB
>          Issue Type: Bug
>          Components: Core/Server
>    Affects Versions: 0.13.0-SNAPSHOT
>            Reporter: xiaozhihong
>            Assignee: Steve Yurong Su
>            Priority: Major
>         Attachments: image-2022-03-14-15-30-00-835.png
>
>
> Ordinary user A enter the CLI, but does not have permission when deleting a storage group, and then enter the CLI as the root user, and a 401 error is displayed during authorization.
> User A :
> {code:java}
> IoTDB> delete storage group root.ln
> Msg: 602: No permissions for this operation DELETE_STORAGE_GROUP {code}
> User root:
> {code:java}
> IoTDB> GRANT USER xzh_01 PRIVILEGES DELETE_STORAGE_GROUP on root.ln;
> Msg: 401: Error occurred while parsing SQL to physical plan: line 1:29 mismatched input 'DELETE_STORAGE_GROUP' expecting {ALL, PRIVILEGE_VALUE} {code}
> The log is:
> !image-2022-03-14-15-30-00-835.png!



--
This message was sent by Atlassian Jira
(v8.20.1#820001)