AUDIT_MANAGING_USERS_PRIVILEGES

Provides summary information about privileges, creating, modifying, and deleting users, and authentication changes.

Provides summary information about privileges, creating, modifying, and deleting users, and authentication changes. This table is a join of LOG_PARAMS, LOG_QUERIES, and LOG_TABLES filtered on the Managing_Users_Privileges category.

Column Name Data Type Description
ISSUED_TIME VARCHAR The time at which the query was executed.
USER_NAME VARCHAR Name of the user who issued the query at the time Vertica recorded the session.
USER_ID INTEGER Numeric representation of the user who ran the query.
HOSTNAME VARCHAR The hostname, IP address, or URL of the database server.
SESSION_ID VARCHAR Identifier for this session. This identifier is unique within the cluster at any point in time but can be reused when the session closes.
AUDIT_TYPE VARCHAR

The type of operation for the audit:

  • Query

  • Parameter

  • Table

AUDIT_TAG_NAME VARCHAR The tag name for the specific parameter, query, or table.
REQUEST_TYPE VARCHAR

The type of query request. Examples include, but are not limited to:

  • QUERY

  • DDL

  • LOAD

  • UTILITY

  • TRANSACTION

  • PREPARE

  • EXECUTE

  • SET

  • SHOW

REQUEST_ID INTEGER The ID of the privilege request.
SUBJECT VARCHAR The name of the table or parameter that was queried or the subject of a query.
REQUEST VARCHAR Lists the privilege request.
SUCCESS VARCHAR Indicates whether or not the operation was successful.
CATEGORY VARCHAR The audit parent category, Managing_Users_Privileges.