Re: Creating schema in oracle10g express edition

dops wrote:
> uhm.. yes all you tell me is true.. but i'm sorry, i continue to think
> that the separation of schemas to the users are more efficient..

Different RDBMS vendors do things differently. That's just the way it is and if you are going to be using oracle you will need to navigate how it's done in oracle.

Or understand how oracle does things first then design a system in oracle that somehow blends away transparently the things that you don't like.

> i want show you a simple situation: think you have a server with one
> oracle instance installed.. this is a web server.. if u have 20
> websites resindent in (for example) iis web server, and all sites
> require the connection of n tables, with one schema u must share the
> same credential with all 20 web site administrators..

20 web site administrators and you are sharing the same credentials? Not quite sure where you are going but that doesn't exactly sound like a good design to me.

> than to create
> separate accounts with oracle u have to create 20 separate schemas..

You could probably do this all in 1 schema in oracle if you had a strong reason to.

If you separate them out you can administer grants and security separately if they are blended together that gets a little more involved.

I have seen systems designed so that a column in each shared table represented which website each row belonged to. I didn't particularly care for that design but that doesn't mean people don't do kludgy things like that. Oracle also provides a VPD ( virtual private database ) feature that you might want to look at.

> else if u have sql server with one database (or schema or container or
> u want tell..) you can create more accounts with more privileges to
> access specificed objects (for example specificed tables or views
> etc..).. same speech with db2..
> it's not a limitation of oracle respect to sql server or db2 concepts?

You lost me here. Oracle does things differently than sql server or db2.

Is it better or worse or just different to have to create 20 databases or 20 schemas?

> i tell you again WHY i've to create a user account to create a
> container!!??

You don't have to do anything in oracle if you want to use a different product. Received on Mon Nov 20 2006 - 18:38:56 CST