Re: [Q] create second schema under a account

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 Received on Wed Dec 29 2004 - 17:09:14 CST