Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: [Q] create second schema under a account

Re: [Q] create second schema under a account

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Wed, 29 Dec 2004 23:45:10 -0500
Message-ID: <33hfe8F3vesnkU1@individual.net>


Howard J. Rogers wrote:
> aaa wrote:
>

>> we have ORACLE 9.2.0.6 on UNIX server.  I know ORACLE support multiple 
>> schemas
>> under a user account.

>
>
> You know wrongly, I am afraid. Since a user more or less *is* a schema
> (and vice versa), then what you say you know to be the case cannot
> possibly be true.
>
>>  Does any know how to do following and give me a sample:
>>
>>    1. create second schema under a user

>
>
> Impossible, taking what you ask for at face value.
>
>>    2. create table or view under second schema

>
>
> This is do-able. Any user, provided they have been granted an 'ANY'
> privilege (for example, 'create any table') can exercise that privilege
> in anybody else's schema. So for example, I could do this:
>
> connect scott/tiger
> create table elmer.employees (col1 char(4));
>
> ...and the EMPLOYEES table has just been created in ELMER's schema. The
> table belongs to Elmer, and Elmer is forever afterwards considered its
> owner. But it was actually created by someone else. Is that what you are
> after?
>
> If not, then you're going to be disappointed! :-)
>
> Regards
> HJR

Given that user management is part of Oracle, isn't it possible (feasable) to create users which have no real life equivalent for the sole purpose of organizing objects? Say to hold all objects which belong to a certain package...

Cheers
Serge Received on Wed Dec 29 2004 - 22:45:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US