Re: connecting automatically as sys

Hans Forbrich wrote:

>
> SQLPLUS /NOLOG
> and return "SYS/{passwd} AS SYSDBA" (no quotes) to the first prompt.
>

Note there are prerequisites to this so my statement is somewhat incomplete. The explanation in the

Oracle9i Database Administrator's Guide
Release 2 (9.2)
Part Number A96521-01
Chapter 1 sections

# Database Administrator Security and Privileges # Database Administrator Authentication

at
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#9122

are pretty easy to read (assming you have OTN access).

If you are concerned about DBAs having access to the data, check out the SYSOPER capability described in the above sections.

HTH
/Hans Received on Sat Jul 24 2004 - 19:39:27 CDT