Help Center> GaussDB> Centralized_2.x> Database Security Management> Managing Users and Their Permissions> Setting Security Policies> Setting the Validity Period of an Account
Updated on 2023-10-23 GMT+08:00
View PDF

Setting the Validity Period of an Account

Precautions

When creating a user, you need to specify the validity period of the user, including the start time and end time.

To enable a user not within the validity period to use its account, set a new validity period.

Procedure

  1. Connect to a database. For details, see Connecting to a Database.
  2. Run the following command to create a user and specify the start time and end time:

    1
    		 
    openGauss=# CREATE USER joe WITH PASSWORD 'xxxxxxxxx' VALID BEGIN '2015-10-10 08:00:00' VALID UNTIL '2016-10-10 08:00:00';

    The user is created if the following information is displayed:

    CREATE ROLE

  3. If the user is not within the specified validity period, run the following command to set the start time and end time of a new validity period:

    1
    		 
    openGauss=# ALTER USER joe WITH VALID BEGIN '2016-11-10 08:00:00' VALID UNTIL '2017-11-10 08:00:00';

    The start time and end time of the new validity period is set successfully if the following information is displayed:

    ALTER ROLE

  • If VALID BEGIN and VALID UNTIL are not specified in the CREATE ROLE syntax, the start time and end time of a user's operation are not limited.
  • If VALID BEGIN and VALID UNTIL are not specified in the ALTER ROLE syntax, the start time and end time of a user's operation are not modified and the original settings are used.