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)