VMware Tanzu Greenplum

  • 1.  Greenplum 7.3.0 -> VALID UNTIL 'timestamp' is not working.

    Posted 18 hours ago

    I have the newest Greenplum Database version -> the 7.3.0.

    I noted that the VALID UNTIL 'timestamp' is not working correctly. I mean if I create user via CREATE USER test_user WITH PASSWORD 'Password123!' VALID UNTIL 'Jul 31 15:30:00 2025 +0' then I can see the correct row in the select rolname, rolvaliduntil from pg_authid where rolname = 'test_user' It means I can connect with this user to the database. The issue is, when the valid until timestamp comes… the new logins are not blocked.


    Link to the documentation: https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/7/greenplum-database/ref_guide-sql_commands-ALTER_ROLE.html



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


  • 2.  RE: Greenplum 7.3.0 -> VALID UNTIL 'timestamp' is not working.

    Broadcom Employee
    Posted 15 hours ago

    Thanks for reporting the issue. We will look into this.

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

    Original Message