GBase 8a
安装配置
文章
数据脱敏之SHA脱敏
发表于2024-12-30 17:43:1544次浏览6个评论
SHA 脱敏对字符列起作用,对列内容应用 SHA 算法处理。
示例:
gbase> CREATE TABLE t_m_sha(context VARCHAR(255) MASKED WITH(FUNCTION = 'SHA()'));
Query OK, 0 rows affected (Elapsed: 00:00:00.08)
gbase> INSERT INTO t_m_sha VALUES('abc');
Query OK, 1 row affected (Elapsed: 00:00:00.10)
gbase> SELECT * FROM t_m_sha;
+------------------------------------------+
| context |
+------------------------------------------+
| a9993e364706816aba3e25717850c26c9cd0d89d |
+------------------------------------------+
1 row in set (Elapsed: 00:00:00.03)
热门帖子
- 12025-12-01浏览数:182759
- 22023-05-09浏览数:25052
- 42023-09-25浏览数:18521
- 52020-05-11浏览数:17526