pgx_assign_profile_to_user(user_name name, profile_name name)

void

Assigns an existing profile to a user.

Specify the assignee user in user_name. If you specify a user name that does not exist, an error will occur.

Specify the profile name to be assigned in profile_name. If you specify a profile name that does not exist, an error will occur.

pgx_lock_user(user_name name)

void

Lock the user explicitly.

Specify the user name in user_name. If you specify a user name that does not exist, an error will occur.

If locked by this function, the lock period is indefinite. If you want to unlock it, you need to unlock it with the pgx_unlock_user function.

If you lock a user that is already locked, the lock state is overwritten and becomes an indefinite lock even if it was previously a finite lock.

pgx_unlock_user(user_name name)

void

Explicitly unlock the user. The type of lock (profile reference lock or permanent lock) does not matter.

Specify the user name in user_name. If you specify a user name that does not exist, an error will occur.

Specifying an unlocked user does not result in an error.

pgx_make_password_expire(user_name name, expireat timestamptz)

void

Expires the specified user's password immediately. Alternatively, specify the time to expire.

Specify the user name in user_name. If you specify a user name that does not exist, an error will occur.

expireat can be a time that expires.expireat is optional. If omitted, execution time is specified.

pgx_make_password_rollover_expire(user_name name)

void

Expires immediately the period during which the specified user's old and new passwords can be used together so that the user cannot log in with the old password.

Specify the user name in user_name. If you specify a user name that does not exist, an error will occur.

If this command is executed outside the period for using the old and new passwords, it is ignored.