David Benoit (7/3/2013)
...Somehow we need to get to the place where we are able to master data access in such a way that people, by job definition, only get to see the data that they truly need, and yet all jobs functions are able to work flawlessly without being constrained by those same restrictions. Utopia? Maybe.
I think it is Utopia, mostly because of the overhead of trying to classify data. too often I think we don't know, or don't have the time to spend doing this. How many people actually set up 3-4 roles in a database, and limit the access? Few do, often because we can't easily classify data or entities for a job, and often because as applications evolve, we need to give access to new tables, or portions of tables.