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

user10408922

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

Gianni Ceresa

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

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

And where are your accounts managed?

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

[Deleted User]

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

It starts in LDAP.

[Deleted User]

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

Federico Venturin - Oracle

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.