Many Oracle tasks require connecting "as sysdba". I would like to schedule these tasks from VC, but currently the SQL task has no option to connect as sysdba. My other alternative is to use an Execute task and run sqlplus, but that means I end up with the password in clear text; not desirable. In addition to ability to run the SQL task with a connection with option as sysdba, please consider creating a password variable type. The password variable should be stored encrypted and always display *****. This would make it possible to pass passwords to executables such as sqlplus and keep the password secure. It would be important also that the password variable not be displayed in any logs other than as *****😝

Hi,

I do not see the problem. Here is a connection string that should work:

User Id=scott;Password=tiger;DBA Privilege=SYSDBA;Data Source=oracle;

---