16.10 - USER DELETE - 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

Removes the referenced user mapping from the list. The user mapping is referenced using the Unity-assigned user mapping ID. You can also use user mapping properties, such as region, user name, account string, and so forth, to specify criteria against which to match user mappings for deletion.

Syntax

USER DELETE <mapId> | <username> <accountstring> <role> <profile> <region>;

Parameters

mapId
Identifier for the user mapping to delete.
You can retrieve the ID by executing the USER LIST command. The user mapping ID is also available from the Unity Configuration portlet interface.
username
Name of the user. Name can contain a maximum of 25 characters.
accountstring
Account string for the user mapping to delete. The account string you specify must be an exact match for the target user mapping.
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

Username of the user mapping to delete must be an exact match to the target user mapping.

Examples

The following example demonstrates how to delete the user mapping mapID 4.

unityadmin>  USER DELETE 4; 
Successfully removed user map 4.

The following example deletes the user mapping for user dbUser2, account string acct*, role *, and profile * values.

unityadmin>  USER DELETE dbUser2 acct* * *; 
Successfully removed user map 3.