Skip to main content
Solved

How to disable single sign on (SSO)


Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1169 replies

Dear IFS experts,

we use IFS APPS 10 and have cloned it from the cloud to our local server.

In the cloud we use SSO. 

How can I disable it for the local installation?

 

Best answer by Link

Link wrote:

Now I’ve found out the way.

I need to set the column ALLOW_DB_AUTHENTICATION to YES. 

 

However, my goal is do that for each user with PL/SQL. 

How can I find out the table name?

The debugger shows nothing.

 

Following tables are needed:

--User table select
Select * from FND_USER_TAB ut;

--Properties select
Select * from fnd_user_property_tab up
where up.name = 'ALLOW_DB_AUTHENTICATION'
and up.value = 'NO';

 

Then I’ve crated a script to update these tables.

 

Now SSO is deactivated on our local hosted IFS test environment.

View original
Did this topic help you find an answer to your question?

5 replies

Forum|alt.badge.img+14
  • Superhero (Employee)
  • 156 replies
  • January 21, 2025

Hi Iskender,

In IFS APPS 10 SSO can be enabled and disabled from the IFS Middleware Server Admin Console page. Please sign in with your “ifs” user and password. Then on the Common / Security page you will need to change Identity Provider to “IFS Database”.

→ Documentation

Best regards -- Ben


Forum|alt.badge.img+23
  • Author
  • Superhero (Customer)
  • 1169 replies
  • January 22, 2025

Hi ​@Ben Monroe 

thank you for your answer.

At first I need to find out the username and password.

Then I will try it.

 


Forum|alt.badge.img+23
  • Author
  • Superhero (Customer)
  • 1169 replies
  • January 27, 2025

Dear ​@Ben Monroe 

the identity provider is already “IFS Database”:

In the cloud we used SSO. All users were created via MS Azure. Then we made an internal clone from this environment.

 


Forum|alt.badge.img+23
  • Author
  • Superhero (Customer)
  • 1169 replies
  • January 28, 2025

Now I’ve found out the way.

I need to set the column ALLOW_DB_AUTHENTICATION to YES. 

 

However, my goal is do that for each user with PL/SQL. 

How can I find out the table name?

The debugger shows nothing.


Forum|alt.badge.img+23
  • Author
  • Superhero (Customer)
  • 1169 replies
  • Answer
  • January 29, 2025
Link wrote:

Now I’ve found out the way.

I need to set the column ALLOW_DB_AUTHENTICATION to YES. 

 

However, my goal is do that for each user with PL/SQL. 

How can I find out the table name?

The debugger shows nothing.

 

Following tables are needed:

--User table select
Select * from FND_USER_TAB ut;

--Properties select
Select * from fnd_user_property_tab up
where up.name = 'ALLOW_DB_AUTHENTICATION'
and up.value = 'NO';

 

Then I’ve crated a script to update these tables.

 

Now SSO is deactivated on our local hosted IFS test environment.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings