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