Re: HELP: create user

Yes you do. For example, to sort some queried data a TEMPORARY TABLESPACE might be necessary (if the sort doesn't fit in the server memory). Even if a user is not allowed to create objects, he/she still needs a DEFAULT TABLESPACE (you can't avoid that in Oracle). And please make sure that the DEFAULT TABLESPACE isn't SYSTEM! If you're using 9i, you can define a default default tablespace for new users (I forget the exact syntax, but look it up if you're interested).

Daniel

> Hi,
> i am a new assigned dba. My question is now, in my db has only one
> tablespace to keep all my table. Now, i want to create a user who
> will not need to create any tables. but only to view data or do some
> data entry. when i create these user do i need to specify the DEFAULT
> TABLESPACE and TEMPORARY TABLESPACE for these users?
>
> T.Q.
>
> regards,
> Lee Cho
Received on Tue Jan 06 2004 - 10:52:35 CST