The following dialog has no help associated with it:
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.
Cheers,
Russ
You can define custom fields in the login window and enter whatever info you want. Click here to do that.
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.
Thank you so much, John.
Too bad Mode is not one of the fields. Bummer.
Hm, yeah that would be a good addition.
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.
No, I'm afraid not. We look in the SESSION_ROLES view for whatever you specify and SYSDBA does not show up there.
But I'll add way to look at Connect Mode in the color rules.
