SHOW USER
Displays configuration parameter settings for database users. To get the names of user-level parameters, query system table CONFIGURATION_PARAMETERS:
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)
Syntax
SHOW USER { user‑name | ALL } [PARAMETER] { cfg‑parameter [,...] | ALL }
Parameters
user‑name | ALL
|
Show parameter settings for the specified user, or for all users. |
[PARAMETER] parameter-list
|
A comma-delimited list of user-level configuration parameters. |
PARAMETER ALL
|
Show all configuration parameters that are set for the specified users. |
Privileges
Non-superusers: Can view only their own configuration parameter settings.
Examples
The following example shows configuration parameter settings for two users, Yvonne and Ahmed:
=> SELECT user_name FROM v_catalog.users WHERE user_name != 'dbadmin'; user_name ----------- Ahmed Yvonne (2 rows)
=> SHOW USER Yvonne PARAMETER ALL; user | parameter | setting --------+-------------------------+--------- Yvonne | DepotOperationsForQuery | Fetches (1 row) => ALTER USER Yvonne SET PARAMETER UseDepotForWrites = 0; ALTER USER => SHOW USER Yvonne PARAMETER ALL; user | parameter | setting --------+-------------------------+--------- Yvonne | DepotOperationsForQuery | Fetches Yvonne | UseDepotForWrites | 0 (2 rows) => ALTER USER Ahmed SET PARAMETER DepotOperationsForQuery = 'Fetches'; ALTER USER => SHOW USER ALL PARAMETER ALL; user | parameter | setting --------+-------------------------+--------- Ahmed | DepotOperationsForQuery | Fetches Yvonne | DepotOperationsForQuery | Fetches Yvonne | UseDepotForWrites | 0 (3 rows)