You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "xiaozhihong (Jira)" <ji...@apache.org> on 2022/11/02 07:27:00 UTC
[jira] [Commented] (IOTDB-3149) There is a difference between adding ** path and without a path to list user privileges
[ https://issues.apache.org/jira/browse/IOTDB-3149?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17627500#comment-17627500 ]
xiaozhihong commented on IOTDB-3149:
------------------------------------
commit dbfacd9c1c85d61c658a151f1cd210ed41b8f44e
I verified.
!image-2022-11-02-15-25-32-903.png!
> There is a difference between adding ** path and without a path to list user privileges
> ----------------------------------------------------------------------------------------
>
> Key: IOTDB-3149
> URL: https://issues.apache.org/jira/browse/IOTDB-3149
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Core/Server
> Affects Versions: master branch
> Reporter: xiaozhihong
> Assignee: 任宇华
> Priority: Minor
> Labels: pull-request-available
> Fix For: 0.14.0
>
> Attachments: image-2022-05-11-10-36-43-442.png, image-2022-10-31-11-13-24-388.png, image-2022-11-02-15-25-32-903.png
>
>
> List the privileges that a user has: After executing without the path (root.{*}{{*}}) and with the path (root.{{*}}{*}), there are differences in the privileges displayed by the user.
> The following SQL shows:
> LIST USER PRIVILEGES user01: Shows all the privileges of the current user.
> LIST PRIVILEGES USER user01 on root.**: Generally speaking, all paths are wildcarded **, but only the privileges of a certain path are currently displayed.
> {code:java}
> IoTDB> LIST USER PRIVILEGES user01;
> +----+-------------------------------------+
> |role| privilege|
> +----+-------------------------------------+
> | | root : SET_STORAGE_GROUP|
> | | root.ln : CREATE_TIMESERIES|
> | |root.** : SET_STORAGE_GROUP LIST_USER|
> | | root.ln.** : CREATE_TIMESERIES|
> +----+-------------------------------------+
> Total line number = 4
> It costs 0.003s
> IoTDB> LIST PRIVILEGES USER user01 on root.**;
> +----+-------------------------------------+
> |role| privilege|
> +----+-------------------------------------+
> | |root.** : SET_STORAGE_GROUP LIST_USER|
> +----+-------------------------------------+
> Total line number = 1
> It costs 0.003s
> {code}
> !image-2022-05-11-10-36-43-442.png!
>
>
>
> This problem has been solved, but new problems have been found.
> The user checks the permissions on the root. sg. ** path, and the root. ** is also matched
>
> !image-2022-10-31-11-13-24-388.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)