Re: [IOTDB-4030] Simplify Privilege Operations SQL

[Jialin Qiao]

Looks good.

Jialin Qiao

On 2022/08/03 03:42:08 Zhou Yifu wrote:
> Hi all,
> 
> 
> Currently, we have a plenty of privilege operations sql which are unfriendly 
> for users. So I try to simplify these privileges operations sql because some 
> of them are redundant and confusing.
> 
> Combine 'LIST ROLE PRIVILEGES ' and 'LIST PRIVILEGES ROLE 
>  on ' to 'LIST PRIVILEGES ROLE  (on )?
> 
> Combine 'LIST USER PRIVILEGES ' and 'LIST PRIVILEGES USER 
>  on ' to 'LIST PRIVILEGES USER  (on )?
> 
> Combine 'LIST USER' and 'LIST ALL USER OF ROLE ' to 'LIST USER (OF 
> ROLE )?
> 
> Combine 'LIST ROLE' and 'LIST ALL ROLE OF USER ' to 'LIST ROLE (OF 
> USER )?
> 
> 
> 
> Feel free to discuss here, thanks a lot!
> 
> 
> 
> Regards,
> Yifu Zhou
> 
> 从 Windows 版邮件发送
> 
> 

Re: [IOTDB-4030] Simplify Privilege Operations SQL

[Zhou Yifu]

Yes, the result set does not have any difference after the change. Just modify 
the upper level of syntax parsing that can adapt both pervious sql.

Yifu Zhou

获取 Outlook for iOS<https://aka.ms/o0ukef>

发件人: 冯 庆新 
发送时间: Wednesday, August 3, 2022 12:12:46 PM
收件人: dev@iotdb.apache.org 
主题: 回复: [IOTDB-4030] Simplify Privilege Operations SQL


I support the change. It seems a lot less "confusing".
But can you list the result set of the statement before and after the change?


发件人: Zhou Yifu<mailto:efuu1...@outlook.com>
发送时间: 2022年8月3日 11:42
收件人: dev<mailto:dev@iotdb.apache.org>
主题: [IOTDB-4030] Simplify Privilege Operations SQL

Hi all,


Currently, we have a plenty of privilege operations sql which are unfriendly 
for users. So I try to simplify these privileges operations sql because some of 
them are redundant and confusing.

Combine 'LIST ROLE PRIVILEGES ' and 'LIST PRIVILEGES ROLE  
on ' to 'LIST PRIVILEGES ROLE  (on )?

Combine 'LIST USER PRIVILEGES ' and 'LIST PRIVILEGES USER  
on ' to 'LIST PRIVILEGES USER  (on )?

Combine 'LIST USER' and 'LIST ALL USER OF ROLE ' to 'LIST USER (OF 
ROLE )?

Combine 'LIST ROLE' and 'LIST ALL ROLE OF USER ' to 'LIST ROLE (OF 
USER )?



Feel free to discuss here, thanks a lot!



Regards,
Yifu Zhou

从 Windows 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>发送

回复: [IOTDB-4030] Simplify Privilege Operations SQL

[冯 庆新]

I support the change. It seems a lot less "confusing".
But can you list the result set of the statement before and after the change?


发件人: Zhou Yifu<mailto:efuu1...@outlook.com>
发送时间: 2022年8月3日 11:42
收件人: dev<mailto:dev@iotdb.apache.org>
主题: [IOTDB-4030] Simplify Privilege Operations SQL

Hi all,


Currently, we have a plenty of privilege operations sql which are unfriendly 
for users. So I try to simplify these privileges operations sql because some of 
them are redundant and confusing.

Combine 'LIST ROLE PRIVILEGES ' and 'LIST PRIVILEGES ROLE  
on ' to 'LIST PRIVILEGES ROLE  (on )?

Combine 'LIST USER PRIVILEGES ' and 'LIST PRIVILEGES USER  
on ' to 'LIST PRIVILEGES USER  (on )?

Combine 'LIST USER' and 'LIST ALL USER OF ROLE ' to 'LIST USER (OF 
ROLE )?

Combine 'LIST ROLE' and 'LIST ALL ROLE OF USER ' to 'LIST ROLE (OF 
USER )?



Feel free to discuss here, thanks a lot!



Regards,
Yifu Zhou

从 Windows 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>发送

[IOTDB-4030] Simplify Privilege Operations SQL

[Zhou Yifu]

Hi all,


Currently, we have a plenty of privilege operations sql which are unfriendly 
for users. So I try to simplify these privileges operations sql because some of 
them are redundant and confusing.

Combine 'LIST ROLE PRIVILEGES ' and 'LIST PRIVILEGES ROLE  
on ' to 'LIST PRIVILEGES ROLE  (on )?

Combine 'LIST USER PRIVILEGES ' and 'LIST PRIVILEGES USER  
on ' to 'LIST PRIVILEGES USER  (on )?

Combine 'LIST USER' and 'LIST ALL USER OF ROLE ' to 'LIST USER (OF 
ROLE )?

Combine 'LIST ROLE' and 'LIST ALL ROLE OF USER ' to 'LIST ROLE (OF 
USER )?



Feel free to discuss here, thanks a lot!



Regards,
Yifu Zhou

从 Windows 版邮件发送