hashhashu / sqltools-Oracle-driver

SQLTools Driver for Oracle
MIT License
5 stars 2 forks source link

How to connect as SYSDBA? #11

Closed felipecrs closed 11 months ago

felipecrs commented 11 months ago

image

I see no way to configure this.

hashhashu commented 11 months ago

yes, it's not supported, i'll add it.

hashhashu commented 11 months ago

Hi, it's updated, please see if it works.

felipecrs commented 11 months ago

Thank you so much, I will check it out at maximum on Monday.

felipecrs commented 11 months ago

It works like a charm. Thank you so much! Tested with:

// .vscode/settings.json
{
  "sqltools.connections": [
    {
      "server": "127.0.0.1",
      "port": 1521,
      "driver": "Oracle",
      "username": "sys",
      "password": "sys",
      "database": "ORCLPDB1",
      "oracleOptions": {
        "privilege": "SYSDBA"
      },
      "name": "Oracle DB"
    }
  ]
}