Social Sign-in Username attribute

Scott Wesley Jan 11, 2019 1:01 AM

We've successfully configured a Social Sign-in authentication scheme, which is great.

We've also been able to make selected attributes to the APP_USER using Username Attribute setting.

However, the attributes in Azure are stored currently in lowercase, so app_user returns "wesleys", not "WESLEYS"

In order to harmonise with existing user & data sets, it would be great if this was uppercase.

Are we able to manipulate this outcome within APEX?

APEX 18.1

Oracle 18.0

ORDS 18.2

Cheers

1. Re: Social Sign-in Username attribute

Christian Neumueller-Oracle Jan 10, 2019 9:22 AM (in response to Scott Wesley)

Hi Scott,

for 19.1, I already added a new attribute "Convert Username To Uppercase" to Social Sign-In.

In older versions, you can use the Post-Authentication procedure to change the name, before it is stored in the session:

procedure post_auth is
begin
apex_custom_auth.set_user(p_user => upper(v('APP_USER')));
end post_auth;

Regards,
Christian
Like Show 1 Likes(1)

Actions
2. Re: Social Sign-in Username attribute

Scott Wesley Jan 11, 2019 1:00 AM (in response to Christian Neumueller-Oracle)

Sometimes APEX just makes things too easy
Like Show 1 Likes(1)

Actions

Join the world’s largest interactive community dedicated to Oracle technologies.