Re: Internal (Oracle 8i(8.1.7)) = Sysdba (Oracle 9i) ???????

From: Imprecise <f_puhan_at_precise.com>
Date: Mon, 10 Jun 2002 14:54:08 -0400
Message-ID: <f_puhan-5781AB.14540810062002@vienna7.his.com>

In article <3D04C854.A880A3CC_at_ford.com>, Reddy <rmallel1_at_ford.com> wrote:

> Is logging in as INTERNAL in Oracle 8.1.7 is exactly similar or
> say...same... as logging
> in as SYSDBA in Oraacle 9i.....in terms of previleges etc.....

The simple answer to your question is, yes. The "internal" account will show itself as SYS in the V$SESSION view when queried. Oracle has long threatened to discontinue its use, and has finally done so with 9i. Expanding the SYSDBA and SYSOPER roles somewhat (well, not really expanding them, but making them play a larger role).

-- 
The underscore character does not belong in my address. You know the drill...
***
Anyone sufficiently smart enough to configure and use USEnet for research should
be smart enough to Read The Freakin' Documentation!

Received on Mon Jun 10 2002 - 13:54:08 CDT