APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get list of users from SSO

User_4BL5VMay 23 2022

My application uses SSO for users to log in which is integrated using SAML.
I would like to know if there is an SQL query that will allow me to retrieve the directory of user email addresses that are allowed to sign in using SAML.
I have a form input in my application that I want to be a list of these users. How would I go about this?

233897

Hi,
it seams to me you installed the ODP.net Package in the same OracleHome-Directory as your database. Because the ODP.net comes as version 9.2 it wouldn't make me wonder if oracle overwrites preexisting files with same names that are binary incompatible. I guess that's the reason you can't restart your 9.0 DB.

182042

ODP.NET is an Oracle9i Rel2 Client based product and should not be installed in a previous Oracle Home. It should be installed either in an Oracle9i Rel2 Oracle Home or a seperate Oracle Home.

1 - 2

Added on May 23 2022

#apex, #apex-discussions, #sql, #sso

2 comments

614 views

1 mention

APEX

Get list of users from SSO

Comments

Post Details