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 <roleName>' and 'LIST PRIVILEGES ROLE 
> <roleName> on <paths>' to 'LIST PRIVILEGES ROLE <roleName> (on <paths>)?
> 
> Combine 'LIST USER PRIVILEGES <userName>' and 'LIST PRIVILEGES USER 
> <userName> on <paths>' to 'LIST PRIVILEGES USER <userName> (on <paths>)?
> 
> Combine 'LIST USER' and 'LIST ALL USER OF ROLE <roleName>' to 'LIST USER (OF 
> ROLE <roleName>)?
> 
> Combine 'LIST ROLE' and 'LIST ALL ROLE OF USER <userName>' to 'LIST ROLE (OF 
> USER <userName>)?
> 
> 
> 
> Feel free to discuss here, thanks a lot!
> 
> 
> 
> Regards,
> Yifu Zhou
> 
> 从 Windows 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>发送
> 
> 

Reply via email to