Re: svrmgrl vs sys account

From: <dgoulet_at_vicr.com>
Date: Sun, 04 Mar 2001 20:29:51 -0800
Message-ID: <F001.002C3755.20010304193521@fatcity.com>

 Boy oh boy, I hope I'm understanding you right. Here is what I think you asking for:

1. Never but NEVER use the sys account for anything unless directed by Oracle Tech Support or their documentation. You can just about forget that this account exists.
2. Do not regularly use the system account either. Create an account/schema for your self with DBA priviledges granted.
3. For each individual user, create a seperate account with their own passwords. For the most part I would NOT allow the sharing of accounts especially if they will be creating objects in the database. Also DON'T use the resource role that Oracle creates. Clone it to something you can control better & remove the "unlimited tablespace" system priviledge.
4. Create an account on all of your databases instances that has the "create session" system priviledge only. This is the only account that I allow to be shared.

Dick Goulet

---------------------- Reply Separator ----------------------

Author: sinardyxing_at_bcsis.com
Date: 3/2/01 5:50 PM

Hi,
I am a beginner DBA could you tell me
what is the diffrent:
create user /tablespace or else using
svrmgrl>
and sys account
oh ya.. I'm using Oracle8i

Thank you very much

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: sinardyxing_at_bcsis.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:
  INET: dgoulet_at_vicr.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). Received on Sun Mar 04 2001 - 22:29:51 CST