SHOW USER

Displays configuration parameter values that are set for a user.

Syntax

SHOW USER user‑name [PARAMETER] { cfg‑parameter [,…] | ALL }

Parameters

user‑name Name of the target user.
cfg‑parameter

Names of one or more user-level configuration parameters. To get the names of user-level parameters, query system table CONFIGURATION_PARAMETERS. For example:

SELECT parameter_name, allowed_levels FROM configuration_parameters 
      WHERE allowed_levels ilike '%USER%' AND parameter_name ilike '%depot%';
     parameter_name      |     allowed_levels
-------------------------+-------------------------
 UseDepotForWrites       | SESSION, USER, DATABASE
 DepotOperationsForQuery | SESSION, USER, DATABASE
 UseDepotForReads        | SESSION, USER, DATABASE
(3 rows)
ALL Shows all configuration parameters set at the user level.

Privileges

Non-superuser: Can only view configuration parameter settings specific to that user.

Examples

=> SHOW USER user1 ALL;
          name           | setting
-------------------------+---------
 DepotOperationsForQuery | Fetches
(1 row)

=> ALTER USER user1 SET PARAMETER UseDepotForWrites=0;
ALTER USER
=> SHOW USER user1 ALL;
          name           | setting
-------------------------+---------
 DepotOperationsForQuery | Fetches
 UseDepotForWrites       | 0
(2 rows)

See Also

ALTER USER