connect as sysdba
- From: "Joe Smith" <joe_dba@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 15 Aug 2006 08:41:57 -0500
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
Other related posts: