Home › Discussions › Questions & Answers › User Name to Description Lookup Utility

User Name to Description Lookup Utility

Avatar photoCustomer Questions & Answers 5 replies

I need to include the full user description next to the Oracle username in my report output. Is there a simple `XXEN_UTIL` function for this, similar to how it works for the system administrator user?

5 replies

  • Support Enginatics

    Yes, the function **`XXEN_UTIL.USER_NAME`** converts a user name or user ID to the full description of the user. For instance, ‘SYSADMIN’ is converted to ‘SYSADMIN (System Administrator)’.

  • Avatar photoCustomer

    Are there overloaded versions of this function?

  • Support Enginatics

    There are overloaded versions that accept either the `p_user_name` (varchar2) or `p_user_id` (pls_integer) as input parameters.

  • Avatar photoCustomer

    Can the user description output be suppressed?

  • Support Enginatics

    Yes, the inclusion of the user description can be deactivated globally by setting the profile option **‘Blitz Report Show User Description’** to ‘No’.

  • You must be logged in to reply to this post.