Devart Forums

I have managed to present the user wit a list of aliases provided by OCI.
Now, after the user has selected a certain database I want to present the user with a list of schema names.

How can I accomplish this, or is it impossible because of e.g. oracle security rules?

Hello

To get list of schemas you should execute the query: select * from DBA_USERS. Without connection to Oracle you cannot get list of schemas because this list depends on user permissions.