HELP: create user

[leecho@unitem.edu.my]

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

[Daniel Roy]

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