Note
For V4.6.x versions, this view is available starting from V4.6.0.
Overview
Displays all users or roles under the current tenant that have plaintext data access permissions on columns associated with a sensitive rule.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| RULE_NAME | varchar(256) | NO | Sensitive Rule Name |
| USER_NAME | varchar(128) | NO | Username |
| USER_TYPE | varchar(4) | NO | User type. Valid values:USERorROLE.USERrepresents a user,ROLERepresents a role. |
Sample query
Query users or roles with plaintext data access permissions on columns associated with a sensitive rule under the current tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_SENSITIVE_RULE_PLAINACCESS_USERS;
The query result is as follows:
+-----------+-----------+-----------+
| RULE_NAME | USER_NAME | USER_TYPE |
+-----------+-----------+-----------+
| r1 | root | USER |
+-----------+-----------+-----------+
1 row in set