Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

how to create a user account in OBIEE 19C with an apostrophe in their name?

Received Response
52
Views
7
Comments
user10408922
user10408922 Rank 1 - Community Starter
edited Aug 13, 2024 7:21PM in Oracle Analytics Cloud and Server

I've tried using _ to replace the apostrophe which has worked in the past but the system still does not recognize the user name.

User name example xxxxx' E-CTR Yxxxxx

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    What exact product and version are you asking about? (OBIEE 19c isn't a thing, doesn't exist)

    What kind of account do you mean? Where/in which part of the product?

  • user10408922
    user10408922 Rank 1 - Community Starter

    We use OBIEE version 12.2.1.4 for our companies reporting tool. We trying to give a particular user access to the OBIEE reports. The users has an apostrophe in their name per the example. Here's an example of the user name,

    Jxxxx' E-CTR Yxxxxx

  • Gianni Ceresa
    Gianni Ceresa Mod

    And where are your accounts managed?

    Did you integrate your corporate AD/LDAP? Are you having SSO?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    As Gianni stated - what's the point of origin for user accounts? Where does an account start its lifecycle? Inside OBIEE/WLS? In an LDAP? In Active Directory?

  • user10408922
    user10408922 Rank 1 - Community Starter

    It starts in LDAP.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    So the question starts there - does your LDAP support user names with apostrophes?

  • Federico Venturin - Oracle
    Federico Venturin - Oracle Mod

    Hi @user10408922 ,

    If your LDAP supports user names with apostrophes (and blank spaces as I can see from your example) and the related security provider has already been configured in OBIEE, I suggest you to double-check that OBIEE is actually able to retrieve the user names from LDAP.

    In WebLogic Console, you have to navigate to Security realms -> myrealm -> Users and Groups -> Users. Does the user name with apostrophes appear in the list? Does it appear exactly as defined in LDAP?

    If there are too many user names, you can expand the Customize this table section and set up a Criteria such as Jxxx* to filter all user names starting with Jxxx.