Re: Stop using SYS, SYSTEM?

NO!!!! You should be using SYS and SYSTEM. You paid for them, so use them! What's the point in not using something that you've paid for? That would be like buying a Ferrari and then not driving it 150 mph along I-95. Who would want to do that?

On 11/12/2003 03:54:25 PM, "Thater, William" wrote:
> Smith, Ron L. scribbled on the wall in glitter crayon:
>
> > We are being asked by Auditing to stop using the SYS, and SYSTEM
> > accounts. They would like for us to create an Oracle Role with the
> > same permissions a SYS and SYSTEM, then grant the role to each of the
> > DBA's. Don't ask me why. Nothing is being audited in 99% of the
> > databases. They just say it in a paper some where so they said we
> > shouldn't use it. This seems like it would cause lots of problems
> > with exports, imports, installs, etc... Has anyone had to deal with
> > this type of request? Any potential problems with making the change?
>
> it would seem to me that this would break things. the only two users Oracle
> can be sure are there are SYS and SYSTEM, just like the only tablespace it
> can be sure is there is the SYSTEM one. and what about running catalog and
> such? i think there are two many possibilities for things to break for me
> to be comfortable with this one.
>
> --
> Bill "Shrek" Thater ORACLE DBA
> "I'm going to work my ticket if I can..." -- Gilwell song
> william.thater_at_carrier.utc.com
> ------------------------------------------------------------------------
> Any intelligent fool can make things bigger, more complex, and more violent.
> It takes a touch of genius -- and a lot of courage -- to move in the
> opposite direction. - Albert Einstein
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Thater, William
> INET: William.Thater_at_carrier.utc.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>

Mladen Gogala
Oracle DBA

Note:
This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mladen_at_wangtrading.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).