This topic describes the syntax of the USER_DISPLAY_NAME function in Hologres.
Description
user_display_name
: maps a Hologres username to the corresponding Alibaba Cloud account or Resource
Access Management (RAM) user.
Synopsis
SELECT user_diplay_name (user_name)
Parameter
- user_name: the name of a Hologres user. Set this parameter to the ID of an Alibaba Cloud account,
such as
13532241323xxx
, or the UID of a RAM user prefixed with p4_, such asp4_23402030200xxx
. - The return value indicates the corresponding Alibaba Cloud account in the format of
xx@aliyun.com
, or the corresponding RAM user in the format ofRAM$mainaccount:subuser
orRAM$public
.
Examples
SELECT user_display_name ('13532241323xxx');
SELECT rolname, user_display_name(rolname) FROM pg_roles;