[Feature][dlink-client] FlinkSQL supports data masking

[HamaWhiteGG]

Search before asking

• [X] I had searched in the issues and found no similar feature requirement.

Description

Support data masking access control at the user/role level, that is, specific users/roles can only access masking data. Similar to Ranger column masking in offline data warehouse Hive.

Use case

1. Take the two rows of data in the order table orders as an example, the sample data is as follows

2. Set data masking policy，the administrator configures users, tables, columns, and data masking conditions, such as the configuration below.

3. User access data When a user queries data in the orders table on Flink, SQL will be regenerated at the bottom layer based on the user's data masking conditions, that is, the data masking will take effect. When user A and user B execute the same SQL below, they will see different result data.

SELECT * FROM orders;

3.1 The result data viewed by user A is as follows, and the data in the customer_name field is completely masked.

3.2 The result data viewed by user B is as follows. The data in the customer_name field will only display the first 4 digits, and the rest will be replaced by x.

Related issues

no

Are you willing to submit a PR?

• [X] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[github-actions[bot]]

Hello, this issue has not been active for more than 30 days. This issue will be closed in 7 days if there is no response. If you have any questions, you can comment and reply.

你好, 这个 issue 30 天内没有活跃，7 天后将关闭，如需回复，可以评论回复。

[github-actions[bot]]

Hello @, this issue has not been active for more than 30 days. This issue will be closed in 7 days if there is no response. If you have any questions, you can comment and reply.

你好 @, 这个 issue 30 天内没有活跃，7 天后将关闭，如需回复，可以评论回复。