RE: Requirement to run as user SYS

  • From: "Goulet, Dick" <DGoulet@xxxxxxxx>
  • To: <Les.Hollis@xxxxxx>, <barb.baker@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 9 Dec 2004 09:30:26 -0500

From Oracle's script:

Rem   Creates data dictionary views.
Rem   Must be run when connected AS SYSDBA

If you connect "as sysdba" then you are SYS.  Try it, if you have a
password file, grant sysdba to yourself (logged on as sys now mind you).
Then logon as yourself "as sysdba".  Then select user from dual; result:

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Hollis, Les [mailto:Les.Hollis@xxxxxx]=20
Sent: Wednesday, December 08, 2004 5:51 PM
To: barb.baker@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Requirement to run as user SYS

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

'/ as sysdba' IS the user SYS

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Barbara Baker
Sent: Wednesday, December 08, 2004 4:45 PM
To: oracle-l@xxxxxxxxxxxxx
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.

On Wed, 8 Dec 2004 14:39:38 -0500, Powell, Mark D <mark.powell@xxxxxxx>
> 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*
> Application of Oracle patch sets and upgrade scripts as specified in
> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Barbara Baker
> Sent: Wednesday, December 08, 2004 2:05 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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
> --
> //
> --
> //

Other related posts: