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: [EMAIL PROTECTED]
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: [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:
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).
