Oracle教程 2023-02-24

Oracle 视图 REDACTION_COLUMNS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图REDACTION_COLUMNS用于列出模式中包含哪些列映射为哪种红加密函数。使用此视图是跟踪在应用程序管理中使用的哪些函数，以及它们被应用到哪些列上的最简单方式。

REDACTION_COLUMNS视图包含以下列：

SCHEMA: 模式的名称
TABLE_NAME: 表的名称
COLUMN_NAME: 列的名称
REDACTION_FUNCTION: 列映射的红加函数
REDACTION_PARAMETERS: 列映射的红加函数的参数

使用此视图的方法是：

SELECT * FROM redaction_columns;
这将返回模式中的所有列映射的红加函数，以及它们的参数。

官方英文解释

REDACTION_COLUMNS describes all redacted columns in the database, giving the owner of the table or view within which the column resides, the object name, the column name, the type of redaction function, the parameters to the redaction function (if any), and an optional description of the redaction policy.

Column	Datatype	NULL	Description
`OBJECT_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the object that is redacted
`OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the object that is redacted
`COLUMN_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the column that is redacted
`FUNCTION_TYPE`	`VARCHAR2(27)`		Redaction function for this column
`FUNCTION_PARAMETERS`	`VARCHAR2(1000)`		Redaction function_parameters for this column
`REGEXP_PATTERN`	`VARCHAR2(512)`		Regular expression pattern to search for
`REGEXP_REPLACE_STRING`	`VARCHAR2(4000)`		Replacement string (up to 4000 characters in length) with up to 500 back-references to subexpressions in the form `\n`, (where `n` is a number from 1 to 9)
`REGEXP_POSITION`	`NUMBER`		Integer counting from 1, giving the position where the search should begin
`REGEXP_OCCURRENCE`	`NUMBER`		Either `0` (to replace all occurrences of the match), or a positive integer `n` (to replace the `n`th occurrence of the match)
`REGEXP_MATCH_PARAMETER`	`VARCHAR2(10)`		To change the default matching behavior, possible values are a combination of `i`, `c`, `n`, `m`, and `x`. See the documentation of the `match_parameter` in the `REGEXP_REPLACE` section of the Oracle Database SQL Language Reference.
`COLUMN_DESCRIPTION`	`VARCHAR2(4000)`		User-provided description of the redaction function that is performed on the column. For example, for a Social Security Number column, the description might be: “redact SSN to XXX-XX-(last 4 digits)”.

本站中文解释

官方英文解释

相关推荐