Home Discussions Questions & Answers Utility Lookup for User Name and Description

Utility Lookup for User Name and Description

Avatar photoCustomer October 29, 2022 at 7:19 pm

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.

Viewing 2 reply threads
  • Author
    Replies
    • Support October 31, 2022 at 4:31 pm  

      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)’.

    • Avatar photoCustomer November 2, 2022 at 5:47 pm  

      Can the description part in parentheses be globally suppressed if needed?

    • Support November 4, 2022 at 6:20 pm  

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

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

Login with: