I feel like I read somewhere that someone was making System Tables out of Secure View, thus allowing them to hide data from users on a row-by-row basis (ideal for sharing configuration files with users from different organizations). I haven't found it here, though. Does anyone have tips on how to do this, assuming this isn't some idle fantasy that I have dreamt up?
Gawain, we use control-grouped views in the System Table module as much as possible in our consortium, but at this point I'm only implementing them for custom tables and/or canned system tables that have an identity property.
I've had in my queue for ages now to implement what Henry Kelly shared at TLCC 2016 in our 'Customizing in a Consortium' session. I haven't tried it, and it might be worth having a TN staff person weigh in on whether this counts as customizing a canned object before you try it.
To be clear, this is for custom (local) System Tables.
Katie Lachance-Duffy was kind enough to share her solution with me, and we implemented it a while back, and it has worked quite well. And you CAN implement it without actually modifying any standard objects. You just might have to pay attention on upgrades, but like I said, it has been great.
Glad to hear it's working for you, John! :)
Gawain, this is definitely doable. Your custom table needs to have an identity property on the ID field, and you'll need to alter UP_POPULATE_REFERENCE_METADATA. John is right; you do have to be careful around upgrades when the canned version is run automatically, but I can send you code later this week if you'd like to take a look.
That sounds great, thank you Katie!