LOG_PARAMS

提供与数据库中运行的身份验证和安全相关的配置参数更改的摘要信息。

示例

以下示例将查询 LOG_PARAMS 系统表并仅显示此用户在“身份验证 (Authentication)”类别下的最新配置参数：

=> SELECT * FROM log_params limit 1;

--------------------------------------------------------------------------------------------------------

issued_time   | 2018-02-12 13:41:20.837452-05
user_name     | dbadmin
user_id       | 45035996273704962
hostname      | ::1:50690
session_id    | v_vmart_node0001-341751:0x13878
audit_type    | Param
audit_tag_name| SecurityAlgorithm
request_type  | UTILITY
request_id    | 8
subject       | MD5
request       | select set_config_parameter('SecurityAlgorithm','MD5',null);
success       | t
category      | Authentication
(1 row)