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: Enterprise manager user creation. Whats wrong?

Re: Enterprise manager user creation. Whats wrong?

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Thu, 22 May 2003 02:33:58 GMT
Message-ID: <3ECC35E5.97FF5746@telusplanet.net>


So have you granted the user priviledges to create tables or other objects? or to use resources? or have you just granted connect priviledge? or have you not granted anything?

Sherlock wrote:

> Yes. thats the point. The first thing i tried was to create a new table
> and it still does not work.
>
> Hans Forbrich wrote:
> > 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 - 21:33:58 CDT

Original text of this message

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