Convert SSO user to local user

Question

“I want to convert a user in my application to no longer use single signon, but rather use username and password to login locally.”

Requirements

  • Basic import knowledge
  • Basic user management knowledge
  • A local user

Information

  • You can’t edit the password of a SSO user (user with the field ‘Identity provider’ set)
  • You can’t edit users passwords when you’re logged as SSO user
  • When a user logs in with SSO the field ‘Identity provider’ is set:

How to solve:

  1. Log in with a local account
  2. Empty the field ‘Identity_provider’ by setting the value to identityproviders:getnull() using import
  3. Change the password of the user

Now the user can login locally (and with SSO as long as you have the identity provider enabled).

Tip:
You can include M9442 to force users to change their password on next (local) login or after the password is expired.

1 Like