RE: connect as sysdba
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'Joe Smith'" <joe_dba@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 15 Aug 2006 10:09:18 -0400
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@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: Joe Smith [mailto:joe_dba@xxxxxxxxxxx]
Sent: Tuesday, August 15, 2006 9:55 AM
To: paul.baumgartel@xxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx
>www.credit-suisse.com
>
>
>
>-----Original Message-----
>From: oracle-l-bounce@xxxxxxxxxxxxx
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Joe Smith
>Sent: Tuesday, August 15, 2006 9:42 AM
>To: oracle-l@xxxxxxxxxxxxx
>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/
>
>--
>//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
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
