Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Monday, October 27, 2008

How to know whether your E-biz instance is SSO enabled

Whenever SSO is enabled, the user_guid column in FND_USER table is populated for all users who have SSO accounts.  Giving the following command 

select user_guid from apps.fnd_user
where user_guid is not null;

If the result is 0 rows, then your instance is not enabled for SSO.
If the result is > 0 rows, then your instance is SSO enabled.

The other obvious way is to try to login to the instance.  If you are presented with the SSO screen for username/password, then you are SSO enabled.

2 comments:

Anonymous said...

This may not be always true.. If we use 3rd party SSO instead of Oracle SSO, then the given SQL will not return any thing even though Ebiz Suite is SSO enabled.

Vikram Das said...

Hi Anonymous,

As per my knowledge, you have to go through Oracle Internet Directory even if you want to use a third party SSO product.

- Vikram