Re: Connecting using Olog() as sysdba

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 15 Jun 2005 01:43:14 -0700
Message-ID: <1118824994.263552.255650@z14g2000cwz.googlegroups.com>

Frank van Bortel wrote:
> mydevnull_at_fastmail.fm wrote:
> > Replying to my own post. I sort of "fixed" this issue using "grant
> > select any dictionary to user" trick. Any cleaner solution would be
> > great!
> >
> > Vinay.
> >
> Was the "as sysdba" syntax supported in 7.x? I only know
> of 'connect internal', but that doesn't mean a thing :)
>
> --
> Regards,
> Frank van Bortel

I pulled this from Oracle 7 server manager docs.

SYSOPER/SYSDBA
The AS clause allows privileged connections by users who have been granted SYSOPER or SYSDBA system privileges, if using a password file, or their operating system equivalents, if using OS authentication.

/
Uses operating system authentication.

INTERNAL
Connects as username SYS via keyword INTERNAL. Should be used rarely and only by the DBA for certain maintenance purposes; requires operating system privileges. CONNECT INTERNAL is supported for backwards compatibility only.

Regards
/Rauf Received on Wed Jun 15 2005 - 03:43:14 CDT