RE: connect as sysdba

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Tue, 15 Aug 2006 10:09:18 -0400
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0F40E782@ENYC11P32005.corpny.csfb.com>

You can't get around it. That's how SYSDBA works.

What do you mean by "use my account as sysdba"?

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: Joe Smith [mailto:joe_dba_at_hotmail.com] Sent: Tuesday, August 15, 2006 9:55 AM
To: paul.baumgartel_at_credit-suisse.com; oracle-l_at_freelists.org Subject: RE: connect as sysdba

Then how do you get around the fact of using the SYS accout?

I don't want to use SYS, I want to use my account as sysdba.

thanks.

>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
>==============================================================================
>

---

Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

---

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 - 09:09:18 CDT