Oracle 视图 DBA_TSDP_POLICY_PROTECTION 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_TSDP_POLICY_PROTECTION用于查看数据库安全策略（Database Security Policy）的保护信息。通过查看它，可以了解到数据库上已经建立的安全策略，以及每个策略所包含的子策略信息。
使用方法：
1. 首先查询该视图，可以通过sql语句“SELECT POLICY_NAME FROM DBA_TSDP_POLICY_PROTECTION”，来查看数据库包含的安全策略名称；
2. 然后通过sql语句“SELECT * FROM DBA_TSDP_POLICY_PROTECTION WHERE POLICY_NAME = ”，来查看特定安全策略的子策略信息。
官方英文解释
DBA_TSDP_POLICY_PROTECTION shows the list of columns that have been protected through Transparent Sensitive Data Protection.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
The schema containing the sensitive data |
|
|
|
|
The table containing the sensitive column |
|
|
|
|
The name of the sensitive column |
|
|
|
The TSDP policy name based on which the column protection was enabled |
|
|
|
|
The security feature enabled on the sensitive column |
|
|
|
|
|
Name of the underlying Oracle security feature policy |
|
|
|
|
The subpolicy of the Transparent Sensitive Data Protection policy based on which protection has been enabled |
See Also:
Oracle Database Security
Guide for more information about using Transparent Sensitive Data Protection
