I need to migrate a FTP into SharePoint, its having around 40000 document in total.
Now concern is this that each document will be having unique Read permission to multiple users and O365/SharePoint Groups.
Also I am making a SPFX (react) based custom table with filter and search option. This table will fetch document from this Document library. Which will restrict the view to the user based on custom queries.
As per my understanding a document library can have 5000 maximum unique permission.
can somebody suggest on how I can achieve this unique permission on one library or is there a way if I can fetch document from multiple document library and showcase in to one SPFX table with search filter.