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 is connecting read-only.
There is no way to do that now. The connection color will be remembered once it is set, and the only thing that can change it is you.
In beta, I did just add a system where you can define desired colors for specific databases/users, etc. When making a new connection, you can click "suggest color" and it will pick one based on the rules you define. But also with this feature, once the color is picked for a connection, nothing can change it except you.
-John
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 privileges to accounts.
We are planning to use 2FA which allow only one DB account per domain user and my idea is to manage access with granting and revoking right DB role upon developer request with Apex application, which we are using now for locking and unlocking accounts with DEV_RW in production DB.
It will be helpful if we can change/set TOAD color on "New Connection" and much more if we can do it while "Test/Reconnect Session". At the end user is one who can use this or not. We can only help them.
I know, long story... PCI DSS...
I hope the picture is clear now.
Best regards,
Igor
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, and user connects, then Toad sees that they have this role, and supposing you want the color for the role to be red. So, we change the color for this connection to red. Ok, fine.
Then the next day they connect again and the role is not there anymore. At this point, I guess you want to color changed back to green? So basically, the presence of the role is like a "color override" without really changing the saved connection color. Yes?
Another question, suppose the user has connections to different databases, but they all have this role. Is it OK if all those connections are the same color?
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 with read write should be "red", read only connections stay default.
We want this to set per-connection as users are connected to several DB from one TOAD and when they switch from one to other DB, it will be fine that user is somehow wart that connection is read write.
Thank you again
Igor