sql - Dynamic data segregation -


i trying create framework in sql ( tables ) me segregate sql data dynamically based on user roles.

e.g. user role should have access data country xyz

i have bunch of stored procedures fetch different attributes of data trying update stored procedures in way stored procedures needs modified once.

i might different filter criteria in future trying create matrix of filter conditions read in stored procedure dynamically filter data.


Comments