| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: connect as sysdba
The TAR was filed under a different CSI, which I no longer have access to.
However, a simple test shows this is true in 10gR2 as well. I remember that
this is a "minor defect" they plan to correct sometime in the future.
SQL > grant dba to test identified by test;
Grant succeeded.
SQL > grant sysdba to test;
Grant succeeded.
SQL > select * from v$pwfile_users ;
USERNAME SYSDB SYSOP
--------------- ----- -----
SYS TRUE TRUE TEST TRUE FALSE
SQL > connect test/test as sysdba
Connected.
SQL > show user
USER is "SYS"
SQL > select version from v$instance;
VERSION
On 8/15/06, Charles Schultz <sacrophyte_at_gmail.com> wrote:
>
> I know in version 9.x, "show user" would ALWAYS return SYS if you logged
> in "as sysdba", no matter what. We talked to Oracle Support about this a
> while back, I'll see if I can dig up that note.
>
>
> On 8/15/06, Joe Smith <joe_dba_at_hotmail.com> wrote:
> >
> > 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
> >
> >
> >
>
>
> --
> Charles Schultz
>
-- Charles Schultz -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 15 2006 - 08:53:08 CDT
 |
 |