Re: connect as sysdba

I know in version 9.x, "show user" would ALWAYS return SYS if you logged in "as sysdba", no matter what. We talked to Oracle Support about this a while back, I'll see if I can dig up that note.

On 8/15/06, Joe Smith <joe_dba_at_hotmail.com> wrote:
>
> List,
>
> I have created a separate user, call it USER granted:
>
> sql>grant connect, resource, dba to USER;
>
> then
>
> sql>grant sysdba to USER;
>
> I can query v$pwfile_users and see USER in there as sysdba.
>
> So why is it whenyou connect as sysdba:
>
> connect USER/pwd as sysdba
>
> that when I type
>
> sql>show user
>
> it returns
>
> user is "SYS"
>
> ?
>
> thanks.
>
> Can't you configure an account to act as sysdba , without using the "SYS'
> account?
>
> thanks.
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Charles Schultz

--
http://www.freelists.org/webpage/oracle-l