I am glad that TOAD is able to use TFS! It’s great for tracking db changes.
I have one suggestion I think would be great. In toad you can view the script for nsql store procedures and it includes the security on that proc which is very helpful!
But when I commit to TFS it only supports the DDL of the sproc. Is there anyway it can also include the grant statements? I hope its easy to do since it pulls it into the script window within toad.
Let me know if this does not make sense I can give you some detail on my request.
The reason I am asking is this is because I can’t alter sproc and have to drop and re-create them every time I make a change so therefore I lose all security once I drop the object.
Thanks for the hard work! Toad rocks!
I am using Toad for DB2 18.104.22.1685.