RE: connect as sysdba
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'joe_dba@xxxxxxxxxxx'" <joe_dba@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 15 Aug 2006 14:49:10 +0100
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
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
