how to segregate files to specific user or create different views based on users??

Question

User-1797368610 posted

Hi,

we have a existing asp.net solution and trying to scale this solution to next level. We are trying to apply some method to segregate files to specific users. Existing solution workflow  is First, We have external users who is uploading the files into sites then everyone in our company and also outside company users who has access right they are able to see all the files. But at this point, we don't want to give the ability to view all the files to outside company user, only they should able to see their project related files(Means only those projects files that we are working together). so what is the best way to deal with this requirement?

Thanks in Advanced! 

Answer 1

User475983607 posted

Craft database tables to map users (or roles) to files.

Answer 2

User-1797368610 posted

Thanks for your quick reply. would like to elaborate more? and also fyi this solution residing into web server and displaying into sharepoint using page viewer web part.

Answer 3

User475983607 posted

Rakib1

Thanks for your quick reply. would like to elaborate more? and also fyi this solution residing into web server and displaying into sharepoint using page viewer web part.

You would be better served if you asked this question in a sharepoint support forum as I'm pretty sure sharepoint has this ability built-in.

Basically,  you would have a table of users, a table of files, and a table that contains the user id to the file id which maps the user to the file.  Use a JOIN to get the files that belong to the current user.

If the application is role driven then map roles to files.  

Answer 4

User-1797368610 posted

As i said sharepoint using just for displaying purpose using by page viewer web part. And i know you can assign permission in sharepoint granular level but issue is if i assign them any level of permission for that page they will able to see all files.

Answer 5

User475983607 posted

Again, I would craft database tables that dynamically map users to files.  The simplest schema is users, files, and user-files.  However, it seems your requirement is a bit more complex as the files are project based.  Perhaps four tables users, projects, user-projects, and project-files.  

Rakib1

As i said sharepoint using just for displaying purpose using by page viewer web part. And i know you can assign permission in sharepoint granular level but issue is if i assign them any level of permission for that page they will able to see all files.

BY the way, this is not common knowledge on an ASP.NET forum which is why I suggested visiting a Sharepoint support forum.  I currently use Sharepoint to share docs with external 3rd parties on a project basis and I don't have this issue.  It's just a matter of configuration.