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 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 809-565-3121 -----Mensaje original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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? _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lalit Batra INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon Estevez INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).