Lalit,
Firstly, you should consider creating seperate instances for
developement and live data usage. It's bad practice to have any kind of
uncontrolled access to live databases such as developers (or even DBAs), no
matter how good they are - sooner or later it will cause problems.
To define 'types' of privilege and access rights to different users,
you can use ROLES. Basically you can assign privs such as SELECT to various
table to a role name 'CASUAL' (for example) and so on.
Your 'users' should not create or own any database object such as tables,
therefore any default tablespace you assign them will not hold data.
Generally I create a tablespace called 'USERS' and set this as defualt TS
for all users. The application objects and data will be available to the
users via privilages via the Roles and possibly via public synonyms.
Your questions are very general so I hope this helps.
Regards,
Mike.
-----Original Message-----
Sent: 07 December 2001 09:55
To: Multiple recipients of list ORACLE-L
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: Jenner Mike
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).
