How can I effectively split update responsibilities on fields within a table between two teams?
consider a table with 25 fields. I want to move the responsibility for data quality (updates) on only 8 of those fields to a different team.
I'm being told to create a new table and move the 8 fields; set update permission on that table to the new team.
My concern is that I have hundreds of queries across the organization that would have to be re-written to do a join of the two tables... seems a bit inefficient to me....