Home Discussions Questions & Answers User Name to Description Lookup Utility

User Name to Description Lookup Utility

Avatar photoCustomer February 28, 2025 at 2:47 am

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?

Viewing 4 reply threads
  • Author
    Replies
    • Support February 28, 2025 at 10:29 am  

      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 February 28, 2025 at 10:51 pm  

      Are there overloaded versions of this function?

    • Support March 1, 2025 at 9:15 am  

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

    • Avatar photoCustomer March 1, 2025 at 12:49 pm  

      Can the user description output be suppressed?

    • Support March 2, 2025 at 11:37 am  

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

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: