Re: TOAD How To connect WITH SYS USER as SYSDBA
From: Burt Peltier <burttemp1ReMoVeThIs_at_bellsouth.net>
Date: Sun, 2 Nov 2003 02:05:36 -0600
Message-ID: <pU2pb.5873$ns.4696_at_bignews4.bellsouth.net>
Date: Sun, 2 Nov 2003 02:05:36 -0600
Message-ID: <pU2pb.5873$ns.4696_at_bignews4.bellsouth.net>
Oops ... 1 character off in following statement I just posted:
Wrong: The older versions of TOAD might now have had the dropdown. Correct: The older versions of TOAD might noT have had the dropdown.
-- "Burt Peltier" <burttemp1ReMoVeThIs_at_bellsouth.net> wrote in message news:eS2pb.5864$ns.1199_at_bignews4.bellsouth.net...Received on Sun Nov 02 2003 - 09:05:36 CET
> How do you know the truncate was done in Toad?
>
> Anyway, I just did a connect via Toad specifying SYS as the user and
SYSDBA
> in the dropdown for connect type.
>
> The older versions of TOAD might now have had the dropdown.
>
> Also, whenever SYS connects in our database a file is created on the
server
> in $ORACLE_HOME/rdbms/audit and it shows things like the client/user O/S
> account and machine/desktop name along with a return code for success or
for
> failure to connect.
>
> I don't recall turning on any auditing, but this audit of SYS (only) is
> being done for 8.1.7.4 on Solaris .
>
> Note: I don't have a Windows Oracle server, but I wonder if you could do a
> connect to SYS if you ran Toad on the Windows server? You might not need
> the SYSDBA dropdown ... maybe if you specify internal as the userid? Just
a
> thought...
>
> --
> "Sidnet" <member46035_at_dbforums.com> wrote in message
> news:3540032.1067506173_at_dbforums.com...
> >
> > When i try 'SYS/password as SYSDBA' in USER/SCHEMA field and blank
> > in PASSWORD Field It show error ORA-01017 invalid USERNAME/PASSWORD
> > Logon denied
> >
> >
> >
> > The problem is that someone has done a truncate table throught TOAD
> >
> >
> >
> > And in the v$sql we can identified the PARSING_USER_ID = 0
> > (corresponding to USER SYS )
> >
> >
> >
> > So i have to search proof of being able to connect through TOAD
> > with USER SYS
> >
> >
> >
> > But i have'nt succeeded in it yet !!
> >
> >
> >
> > How can i get the real user who mad this truncate !!!!
> >
> >
> > --
> > Posted via http://dbforums.com
>
>