Re: TOAD How To connect WITH SYS USER as SYSDBA

[Quoted] 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 [Quoted] 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 [Quoted] 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 [Quoted] 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 [Quoted] 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