Re: Can I make multiple schemas from one user?

Since a schema *is* a user, the answer is no.

A schema is merely a collection of objects owned by a user, so if EMP is owned by SCOTT and DEPT by MARY, then you have two objects, in two schemas, and there happen to be two users.

It is true that MARY could issue the command 'create table scott.emp' (she needs the Create ANY table privilege' to do so), and in that sense you've got one user creating things in two schemas. But you'd need to create a user SCOTT before she could do it, and the EMP table still ends up being created in SCOTT's schema.

So you still end up with number of schemas=number of users (except that you might also have users that merely use objects in other people's schemas and never create any of their own, in which case number of schemas>number of users).

Regards
HJR "dlaurent" <dlaurent_at_amcat.com> wrote in message news:6ad08732.0212201436.5434766f_at_posting.google.com...
> Can I make multiple schemas from one user? And if so How do I do it?
>
> Dave
Received on Fri Dec 20 2002 - 16:58:13 CST