Home › Discussions › Questions & Answers › User Lookup by ID using XXEN_UTIL

User Lookup by ID using XXEN_UTIL

Avatar photoCustomer Questions & Answers 5 replies

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?

5 replies

  • Support Enginatics

    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

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

  • Support Enginatics

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

  • Avatar photoCustomer

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

  • Support Enginatics

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

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