1) We are getting list of users from SFDC portal, this would be dumped in SQL table
2) Each user would be having some attributes based on which we will be executing row, object, stream level security.
Now i know how to apply custom properties and achieve above security requirements, the issue is we have more than 4000 users so this manual task would be cumbersome of applying properties inside each user,
is there a way to group user and apply security on Group?(i assume we cant use custom group as users are coming from Sql table)
Also in future if new users are created can they be added to this group automatically based on their attributes?