RE: connect as sysdba

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Tue, 15 Aug 2006 14:49:10 +0100
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0F40E780@ENYC11P32005.corpny.csfb.com>

Connecting AS SYSDBA effectively creates a connection as SYS.

Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Joe Smith Sent: Tuesday, August 15, 2006 9:42 AM
To: oracle-l_at_freelists.org
Subject: connect as sysdba

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

---

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

---

--

http://www.freelists.org/webpage/oracle-l Received on Tue Aug 15 2006 - 08:49:10 CDT