Can someone 'splain that dialog to me? I am especially curious what fields are meant by "Search Field: Custom Fields". Would it allow me to automate the colorifying of SYSDBA connections? It appears not, but there is no doco stuffs to assist me with that feature.
if you set up some custom fields, the color rule feature can search them to decide which connection color to use.
If you don't use custom fields, the column suggestion rule can look at the LDAP or TNSNames entry name, or user name, or Alias. If it finds a match for the "Search value" in any of these places, the rule will pass and that rule will give a color for the connection. Otherwise, it will move on to the lower priority rules looking for a match.
Toad 2025 R2, which is due out next month, will have a "role override" color that you can assign per-connection.
So for example, a connection could be defined as green, but if you connect and it turns out the DBA role (or whatever role you want) is enabled, then the color dynamically switches to red.
Great! Would SYSDBA work? It is not actually a role but more like a "sudo to root" in the database. A SYSDBA connection is a connection to the SYS user.