Re: TOAD How To connect WITH SYS USER as SYSDBA

From: Sidnet <member46035_at_dbforums.com>
Date: Thu, 30 Oct 2003 04:29:33 -0500
Message-ID: <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
Received on Thu Oct 30 2003 - 10:29:33 CET

Original text of this message