Hi We would like to change TOAD theme/color settings when starting new session or reconnecting current one depends on database role. We want to have different displays if the session is read only or read write. Is this possible and how? Best regards Igor

I think it is only possible with connection colors, but Quest has recently improved that so that the colors are more prominent. Cheers, Russ

Thanks for your answer. We use connection colors, but we want to change them depends on database role that user is granted when connecting to DB to warn user that session is read write or not. Regards, Igor

HI Igor, I'm not clear on what you are asking for. Is this right? When making a connection, if user has some specific role (I guess you would have to define the role we are looking for), then change the existing connection color if user is connecting read-write, but don't make any change if user …

Hi John Yes, that was my question. Why do we need this? In production DB we have two accounts per developer. One for read only access and second for full. Developer can use color setting to distinguish those two accounts in TOAD. We have two DB roles DEV_RO and DEV_RW for granting and revoking pri…

Oh ok. I see. You aren't using Toad's "read only" option, you are controlling this by a role. I thought you were using both. That simplifies things a bit. But I still have more questions... Let's say you have a connection defined in Toad with the color green. If this feature were implemented…

Hey John, I REALLY like this idea. We could make good use of it. Cheers, Russ

Would a global option like "override connection color with red (or some other color) if role _____ is detected" work, or is this something that you'd like to set on a per-connection basis?

Hi John We ware patching over the weekend and I did not answer... Next day color can changed back to default. It is much easier then remember what was the color before "red". And yes, "color override" is what we want. If user is connected to different DB from same TOAD program, only connections w…

Ok, this will be in the next beta. Set it up here in Edit Login Record [image] Or here in the grid: [image] If you have an override color and role defined, we'll check to see if it's in SESSION_ROLES and adjust connection color accordingly after connection is made, and after your run a SET RO…

Hi John First, thank you for you very fast response and second, where and when I can download new beta version? Best regards from Slovenia Igor

Can we change TOAD theme/color settings depends on database role

Toad for Oracle & DevOps Toolkit

JohnDorlon December 6, 2024, 1:19pm 12

You can get it here.

We release an update almost every monday.

Topic		Replies	Views
TOAD 17 New Feature: Connection Color on Title Bar Toad for Oracle & DevOps Toolkit	9	600	August 29, 2024
Assign a color to TOAD when starting from shortcut with connection-info Toad for Oracle & DevOps Toolkit	8	2199	February 28, 2018
A quick question for those of you who like connection colors Toad for Oracle & DevOps Toolkit	14	1282	February 28, 2024
Connections.xml where does TOAD get the default values from (like <color>16777125</color> Toad for Oracle & DevOps Toolkit	11	1249	February 1, 2023
TOAD 6.5: bug with Connection Manager color scheme Toad for SQL Server	2	838	October 16, 2014

Can we change TOAD theme/color settings depends on database role

Related topics