16.10 - USER LIST - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty

Purpose

Lists the defined user mappings and optionally filters by matching criteria.

Syntax

USER LIST [ <username> [ <accountstring> [ <role> [ <profile> [ <region> ] ] ] ] ];

Parameters

username
Name of the user. Name can contain a maximum of 25 characters.
accountstring
Account string of the user mapping to list.
role
Role of the user mapping to delete. This must be an exact match to the target user mapping.
profile
Profile of the user mapping to delete. This must be an exact match to the target user mapping.
region
Specifies either the name of a Unity region or asterisk (*) to indicate any region. Use this parameter to determine a match with the logon Endpoint's region. If you do not specify a region, the default asterisk (*) is used to specify any region.

Usage Considerations

The user ID determines the order in which the user mappings are matched. For each new connection, Unity chooses the user mapping with the lowest ID matching the session user name, region, account string, role, and profile.

Examples

The following example executes the USER LIST command without parameters.

unityadmin>  USER LIST; 
ID              User    Account Role    Profile Routing
================================================================================
1               *       *RB*    *       *       rbRouting 
2               mark    *       *       *       readOnlySys1
3               *mktg*  *       *       *       readSys1
4               robert  acct4   dba     *       prefReadOnly 
99999           *       *       *       *       DefaultRouting

The following example performs a search for a specific user mapping.

unityadmin>  USER LIST mark; 
2               mark    *       *       *       readOnlySys1

The following example performs a search for a user mapping that matches wildcards.

unityadmin>  USER LIST report_mktg_3 acct2 rpt_role; 
3               *mktg*  *       *       *       readSys1

The following example performs a search with more details.

unityadmin>  USER LIST robert acct4 dba; 
4               robert  acct4   dba     *       prefReadOnly

The following example performs a search with more details.

unityadmin>  USER LIST robert local dba; 
99999           *       *       *       *       DefaultRouting