I have granted the user DBA role with admin option. What is surpirsing
is that i have done this earlier without any problem.
Hans Forbrich wrote:
> 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:56:53 CDT
