allow schema-level environment category labelling
In the Database Connection Properties dialog, you can set the Environment Category to Production/Test/etc.
I have multiple instances where one database server holds the Test and Production schemas. It'd be nice to be able to label each schema accordingly.
John Eckhardt
shared this idea
-
Vitaly Ketsenko
commented
I had another idea, but this can also solve my issues.
Current implementation that category is selected by connection&database doesn't really work well. In my case I have 2 connections to the same database, but with different user, one is root and another have readonly permissions. Obviously I would like to have root connection marked red and readonly connection marked green. However, whenever I change category in one conneciton it's automatically changed in another
What I suggest is make system a little bit dumber, because now it's "too smart". Category must be assigned per connection as UI suggests, but not per ip+database
To John, I suggest you also create 2+ connections with different users, 1 have access to production databases, another - to test databases