Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Requirement to run as user SYS

Re: Requirement to run as user SYS

From: Barbara Baker <barb.baker_at_gmail.com>
Date: Wed, 8 Dec 2004 15:44:58 -0700
Message-ID: <47a6f72b04120814444da771bc@mail.gmail.com>


OK, NOW I need something from Oracle that says not just that these things SHOULD be run as SYS, but that they MUST be run as SYS.

Anyone know of anywhere in the documentation where it says something like 'if you don't run this as SYS and it blows up, you're on your own??' or 'if you don't use the SYS acct to migrate, you're screwed'??

Please help me. If you cannot provide any documentation, then take a silent moment to feel sorry for me.
thx
barb

On Wed, 8 Dec 2004 14:39:38 -0500, Powell, Mark D <mark.powell_at_eds.com> wrote:
> Under OS group authentication for sysdba users:
>
> Start/Stop/Recover the db
>
> Run Oracle provided scripts that specify that the script is to be ran as SYS
> such as optional $ORACLE_HOME/rdbms/admin/cat*, dbms*, and utl* scripts.
>
> Application of Oracle patch sets and upgrade scripts as specified in the
> installation documentation
>
> It looks like this pretty much matches what you took from the manual.
>
> HTH -- Mark D Powell --
>
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Barbara Baker
> Sent: Wednesday, December 08, 2004 2:05 PM
> To: oracle-l_at_freelists.org
> Subject: What operations should be performed as SYS
>
> Have any of you had to define (for SOX or otherwise) what specific
> operations should be performed by SYS versus other administrative
> operations that can be performed by a user granted DBA privilege? If
> so, are you willing to share?
> (Help me! The auditor is on my tail. mayday mayday)
>
> Here's a list I came up with from the Database Administrator's Guide.
> However, I'm not too happy with it. Any additions/changes would sure
> be helpful.
> Thanks!
> Barb
>
> Perform startup and shutdown operations
> Alter database: open, mount, back up, or change character set
> Create database
> Create or modify init or spfile
> Alter database commands
> Archivelog and recovery commands
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 08 2004 - 16:44:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US