Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: some DBA help.
Lalit,
1-) You should use roles for each type of user that you would have in the
db, in that
way every time you have to add a user you just assign that role.
2-) The tablespaces that you default the users, depends in the schema of
your organization,
you can have a development computer and assign the developers to it, and the
production
database in another computer and assign the users to it, as I said it
depends of your
schema.
3-) The users are the ones to insert, update and delete data so they must be
assigned
the final or production tablespace.
Regards,
Ramon E. Estevez
com.banilejas_at_codetel.net.do <mailto:com.banilejas_at_codetel.net.do>
809-565-3121
-----Mensaje original-----
De: root_at_fatcity.com [mailto:root_at_fatcity.com]En nombre de Lalit Batra
Enviado el: Friday, 07 December, 2001 4:55 AM
Para: Multiple recipients of list ORACLE-L
Asunto: some DBA help.
Assume that you are starting a new database and that you need to start
adding user to this database. There are three basic types of users:
developers (who can create basically all objects in the database), data
processors (who can insert data into a given set of tables -CUSTOMER and
ORDER TABLE as well as updates these tables) and casual user (who can view
data from the INVENTORY and PARTS table). Assume also that every day there
may be an unpredictable number of users to be added to the different types
of categories. As a DBA, what can you do to make the task of adding user a
little bit simpler?
Would we assign developers and data processors to the same table space? Why
or why not?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lalit Batra INET: lalitbatra_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Fri Dec 07 2001 - 08:27:55 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon Estevez INET: com.banilejas_at_codetel.net.do Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |