黑白名单-SYS_BLACK_WHITE_LIST

📄字数 750

👁️阅读量 加载中...

功能描述

SYS_BLACK_WHITE_LIST系统表用于记录当前节点的黑白名单。

字段说明

序号	字段名	类型	说明	V11	V12
0	NODEID	INTEGER	节点ID	√	√
1	LIST_TYPE	VARCHAR	名单类型	√	√
2	DB_NAME	VARCHAR	库名	√	√
3	USER_NAME	VARCHAR	用户名	√	√
4	IP_RANGE	VARCHAR	IP范围	√	√

应用举例

• 查询黑白名单

SQL> SELECT * FROM SYS_BLACK_WHITE_LIST;
+--------+-----------+---------+-----------+----------+
| NODEID | LIST_TYPE | DB_NAME | USER_NAME | IP_RANGE |
+--------+-----------+---------+-----------+----------+
| 1      | whitelist | everydb | everyone  | anywhere |
+--------+-----------+---------+-----------+----------+

• 增加一个白名单，允许用户user_white从192.168.10.50至192.168.10.60这个IP地址段访问数据库monitor_db

SQL> CREATE DATABASE monitor_db;
SQL> CREATE USER user_white IDENTIFIED BY '123@';
SQL> ALTER CONNECT POLICY ADD ENABLE 'user_white' LOGIN 'monitor_db' FROM '192.168.10.50' TO '192.168.10.60' ON ALL NODE;

SQL> SELECT * FROM SYS_ALL_BLACK_WHITE_LIST WHERE db_name = 'monitor_db';
+--------+-----------+------------+------------+-----------------------------+
| NODEID | LIST_TYPE |  DB_NAME   | USER_NAME  |          IP_RANGE           |
+--------+-----------+------------+------------+-----------------------------+
| 1      | whitelist | monitor_db | user_white | 192.168.10.50-192.168.10.60 |
| 2      | whitelist | monitor_db | user_white | 192.168.10.50-192.168.10.60 |
| 3      | whitelist | monitor_db | user_white | 192.168.10.50-192.168.10.60 |
+--------+-----------+------------+------------+-----------------------------+

相关系统表

• SYS_ALL_BLACK_WHITE_LIST