As I found, this has some confusing side effects:
I chose a site that was a savage evil swamp, had a hidden volcanic vent (found via the search tool), perfectly flat terrain, and an aquifer level under two layers of rockless soil. Having just abandoned an above-ground wooden fortress that went horribly awry, I opted to go with the subterranean approach and brought enough material to encase the wagon and downward stairs in an impenetrable building. Since I anticipated working with magma, I chose bauxite.
All of my early buildings were made with the surplus of bauxite. Eventually I deconstructed some of them, but to my annoyance my mason was going out of his way to make furniture from my precious magma-proof stone, so I went into the stock screen and forbade all of it.
This was in middle of a dwarven caravan arriving, about twenty lumber haulers spamming order cancellations due to kobold thieves and zombie slugmen, and setting up a channeling project for the recently discovered magma pipe. It was swiftly forgotten in the chaos.
When things settled down I noticed that my head brewer/cook was sitting around twiddling his thumbs. I ensured he had no other jobs set, tried setting other dwarves to brew or cook, and even attempted to deconstruct the buildings, but couldn't even do that. I built a new brewery and kitchen and my head chef went back to work, so something was obviously wrong with the original buildings.
A shower and wild theories about my wagon possibly queuing jobs later, I checked the contents of one of the buildings with "t" -- and the bauxite building material had double parenthesis. I had accidentally forbidden the building without realizing it.
tl;dr, perhaps it would be a good idea to not make workshops forbiddable from the stock screen.