Doh! Why didn't I think of that...super idea, and simple too.
Many thanks Erwan!
(It's been bugging me for about 6 months - should have asked before!)
Roger
>
> Hi,
>
> A workaround:
> You could create 2 aliases on you production DB and set a different color for each of them.
> Pre-set the username so that no confusion is possible
> ex:
> PRODDB - Readonly, colored green, with your read only user in the username field
> PRODDB - Admin, red, with your write-capable user in the username field
>
> Erwan
>
>
>> Date: Thu, 22 Sep 2011 16:30:07 +0100
>> From: rh...@hi...
>> To: squ...@li...
>> Subject: [Squirrel-sql-users] Enhancement request
>>
>> Hi.
>>
>> Squirrel already lets me put a coloured border around a production database, so it is easy to
>> distinguish between production and test, say.
>>
>> Would it be possible to make the border dependent on the login being used, as well as the
>> database?
>>
>> My problem is that I have two separate logins to production, one read-only for running queries
>> etc, and one with write capability as well, to be used for data fixes and the like. It would be
>> nice to be able to distinguish the two sessions easily.
>>
>> I realise that this will probably need some sort of configuration option to be set up, so that
>> the
>> user-id and alias combinations can be recorded.
>>
>> Thanks
>> Roger
>>
>> ****************************************
>> Roger Hill
>> ****************************************
>>
>>
>> ------------------------------------------------------------------------------
>> All the data continuously generated in your IT infrastructure contains a
>> definitive record of customers, application performance, security
>> threats, fraudulent activity and more. Splunk takes this data and makes
>> sense of it. Business sense. IT sense. Common sense.
>> http://p.sf.net/sfu/splunk-d2dcopy1
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
****************************************
Roger Hill
****************************************
|