| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: some DBA help.
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?
--
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-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: M.Jenner_at_southampton.gov.uk
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). Received on Fri Dec 07 2001 - 09:45:43 CST
 |
 |