Re: users and schemas and who can use which

On 24 Aug 2005 10:41:17 -0700, "brightspot" <brightspot5_at_hotmail.com> wrote:

>Hi,
>
>I have a java program that prompts the user for his/her login name. I
>want to use the login name to find out which of the many schemas in my
>database he/she is allowed to see and present that list in a drop down
>menu.
>
>Is there any way in the Oracle system tables to set this up using roles
>or privileges or profiles (or anything else) and then querying the
>system tables to check to see who can see what?

There is, but your question is vague.

We are doing this in
>SQL Server (using system tables) now, and I was wondering if there is a
>similar mechanism in Oracle.
>
>Or do we have to set up our own user-schema table and do the query that
>way?
>
>TIA
>Chris

No, you don't.
Just read the Concepts manual, and get an idea of the Oracle architecture.
Just forget anything you learned and don't try to 'port' your bad habits to Oracle.

--
Sybrand Bakker, Senior Oracle DBA