SDDM has neat feature for documenting on column level what is sensitive information. I shamemyself always when neglecting the security tab in Table.Columns edits. It deserves more attention seriously!
So some findings about the usage of those definitions.
- Sensitive columns are visualized with red font in relational view - this is pretty good.
- The sync with dictionary right arrow/or table ddl preview doesn't give DDL snippets for changes on “table - columns - security tab” managed changes. Can that information be pushed somehow to dictionary? And how about left-arrow sync?
- Haven't figured out how the masking type / template could be configured, reported and pushed to database to make solid dictionary driven setup for hiding,masking,obfuscing data? Maybe features which enables more detailed levels/categorizations to be added would make it even more usable and strengthening the idea to protect the data from the source. While rasadm for ras is not avail it would be good to be able to map those definitions with ras with some generic way.
- So it would be good to have this information carried to database dictionary somehow? Also managing these values via dbactions datamodeler would be very good addition. While it seems that also Vscode SDDM will co-exist then similarly the featurettes would be good to have in all of the SDDM's to avoid breaking the definitions between tools. (similarly e.g the column “D” deprecated value would be good to have in sync).
- From visualization point of view the sensitivities would be very good to be formatted e.g. colored / background colored in all tools.
rgrds Paavo