By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

HELP: create user

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.