Re: Enterprise manager user creation. Whats wrong?

Sherlock wrote:

> Greetings,
>
> I am using Oracle 9i on Windows 2000. I came across a weird problem (?)
> while creating a new user. A schema, i understand is a collection of
> objects owned by a User. To create a new user, i first create a new
> tablespace for that user. After that i create a new user and assign the
> tablespace to him. I understand that 'create user test identified by
> test' command will create a new schema, called test.
> But when i create a user yesterday in the enterprise manager, a new user
> is shown. But a new schema is not shown in the enterprise manager. I can
> see the user i created under "Security-->Users", but not under "Schema"
> I have created 5-6 users earlier, but have not experienced this problem(?).

The direct answer is: if your user is capable of holding objects, then the moment you add an object it will show up under the Schema section. I just test this - same environment.

However, and with all due respect, what documentation have you read to provide the definition of User, Schema, Tablespace, etc. I believe your problem statement indicates some fundamental confusion & the long answer of trying to unravel the confusion might be better. Received on Wed May 21 2003 - 20:24:04 CDT