connect as sysdba

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Tue, 15 Aug 2006 08:41:57 -0500
Message-ID: <BAY107-F350B1DB078FF7D92895EF1974F0@phx.gbl>

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

Received on Tue Aug 15 2006 - 08:41:57 CDT