Credential support

Add credentials (dba_credentials) to the schema browser along with create/drop/update (dbms_credential)

When creating a db link, allow selection of credentials instead of username/password.

When generating a script for a DB Link that uses a credential - include credential syntax if the link authenticates with a credential.

Hi Sean,

Go to Schema Browser -> Scheduler Credentials.

Those are from dba_credentials and the create/alter window uses dbms_credential.

What we don't have yet is the ability to use them from create/alter db link (or the script). I'll add that to my list.

-John

ah - thanks for the Sched Credentials - didn't even think to look under scheduler even though that was the original intent for them.

looking forward to the db link functionality

I've added it for next beta to the following places in Toad

  • SB -> DB Link -> RHS Info Tab
  • Create/Alter DB Link
  • DB Link Script (Generate Schema Script, Export DDL, Schema Browser Script Tab)
  • Schema Compare
  • SB -> Sched Credentials -> RHS Used By Tab
1 Like