Utility Lookup for User Name and Description

I need a quick way to include the full user description next to the Oracle username in my reports, especially when only the user ID is available.

3 replies

Support Enginatics October 31, 2022
The function `XXEN_UTIL.USER_NAME` is overloaded to handle both user name (`p_user_name in varchar2`) and user ID (`p_user_id in pls_integer`) inputs. It converts the input to the full description of the user; for instance, ‘SYSADMIN’ is converted to ‘SYSADMIN (System Administrator)’.
Customer November 2, 2022
Can the description part in parentheses be globally suppressed if needed?
Support Enginatics November 4, 2022
Yes, the inclusion of the user description can be deactivated globally by setting the profile option ‘Blitz Report Show User Description’ to ‘No’.