Pivotal Knowledge Base

Follow

How To Find User Creation Date in Greenplum

Environment

 Product  Version
 Pivotal Greenplum  4.3.x
 OS  RHEL 6.x

Purpose

This article describes how to find a role creation date.

Procedure

In order to find out when a role had been created, issue the following SQL query:

gpadmin=# SELECT rolname,actionname,TO_CHAR(statime, 'DD-MM-YYYY HH24:MI:SS') AS "action date" from pg_roles AS r LEFT JOIN pg_stat_operations AS o ON r.oid=o.objid WHERE actionname='CREATE' AND rolname = 'gpmon';
 rolname | actionname |     action date
---------+------------+---------------------
 gpmon   | CREATE     | 24-10-2016 03:18:34
(1 row)

 

 

Comments

Powered by Zendesk