LOG_QUERIES
提供与在数据库中运行的身份验证和安全相关的一些查询的摘要信息。
示例
以下示例将查询 LOG_QUERIES 系统表并仅显示该用户在 Managing_Users_Privileges 类别下的最新查询:
=> SELECT * FROM log_queries limit 1;
---------------------------------------------------------------------------
issued_time | 2018-01-22 10:36:55.634349-05
user_name | dbadmin
user_id | 45035996273704962
hostname |
session_id | v_vmart_node0001-237210:0x37e1d
audit_type | Query
audit_tag_name| REVOKE ROLE
request_type | DDL
request_id | 2
subject |
request | revoke all privileges from Joe;
success | f
category | Managing_Users_Privileges
(1 row)