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

User ID Lookup by Name using XXEN_UTIL

Avatar photoCustomer December 21, 2020 at 3:41 am

I need a utility function that simply returns the numeric user ID (`user_id`) when given an Oracle username.

Viewing 0 reply threads
  • Author
    Replies
    • Support December 21, 2020 at 10:57 am  

      You should use the function `XXEN_UTIL.USER_ID(p_user_name in varchar2)`. For example, querying `xxen_util.user_id(‘SYSADMIN’)` returns `0`.

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

Login with: