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?
Solved
How to disable single sign on (SSO)
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.
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”.
Best regards -- Ben
1 person likes this
Hi
thank you for your answer.
At first I need to find out the username and password.
Then I will try it.
Dear
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.
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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.