Obtain a list of available schema's

h.hasenack · Post by **h.hasenack** » Tue 22 Jun 2010 12:38

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?

bork · Post by **bork** » Thu 24 Jun 2010 14:52

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.