RE: Requirement to run as user SYS

From: Hollis, Les <Les.Hollis_at_ps.net>
Date: Wed, 8 Dec 2004 16:51:20 -0600
Message-ID: <FCC960FDB92F5E469A02464FF72872F4030F1CD9@pscdalpexch50.perotsystems.net>

The documentation DOES say to log in using sqlplus '/ as sysdba'

'/ as sysdba' IS the user SYS

-----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 4:45 PM To: oracle-l_at_freelists.org
Subject: Re: Requirement to run as user SYS

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:

>=20

> Start/Stop/Recover the db

>=20
> 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.
>=20
> Application of Oracle patch sets and upgrade scripts as specified in
the
> installation documentation

>=20

> It looks like this pretty much matches what you took from the manual.

>=20

> HTH -- Mark D Powell --

>=20
>=20
>=20
>=20

> -----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

>=20

> 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)

>=20

> 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

>=20

> 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
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 08 2004 - 16:50:36 CST