Home Discussions Questions & Answers User Lookup by ID using XXEN_UTIL

User Lookup by ID using XXEN_UTIL

Avatar photoCustomer January 21, 2022 at 9:52 am

I am working with tables that only store `user_id`. Is there an overloaded version of `XXEN_UTIL.USER_NAME` that accepts the user ID to return the username and description?

Viewing 4 reply threads
  • Author
    Replies
    • Support January 23, 2022 at 11:02 am  

      Yes, the overloaded function **`XXEN_UTIL.USER_NAME(p_user_id in pls_integer)`** returns the user name and user description based on the user ID.

    • Avatar photoCustomer January 25, 2022 at 3:12 am  

      If I pass user ID 0, what description is returned?

    • Support January 25, 2022 at 11:45 am  

      The SQL statement `select xxen_util.user_name(0) from dual` returns ‘SYSADMIN (System Administrator)’.

    • Avatar photoCustomer January 25, 2022 at 4:17 pm  

      Can I prevent the description (in parentheses) from being shown if needed?

    • Support January 25, 2022 at 10:20 pm  

      Yes, the user description part of the output can be deactivated 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: