1 Reply Latest reply on Apr 6, 2009 11:56 AM by Jade

    Limiting access to specific records...

    jda76

      Title

      Limiting access to specific records...

      Post

      Hi...

       

      We have an existing db of art specs for a multitude of projects.  Users can search for the project title they want and browse through the specs for that project.  Nothing fancy.  Once the user has gone to their chosen project, there is a search button that allows them to perform a find, but within whatever project they happen to be on.  If they want to go to a different project, they have to go back to the 'home' layout and choose a different project from there.  And this is accessed via IWP.

       

      We would now like to provide access to this file to freelance users.  We don't want them to be able to view all projects - only the project(s) they are assigned to.

       

      I don't seem to see anyway to limit access to specific records based on privilege sets.... am I missing something?

       

      I created a new table called "Freelance Users", which lists the assigned freelancer's account name and the projects they can have access to.

      I have thought of setting up a value list on the 'home' screen that will only display the titles assigned to that user, as well as limiting layout access and controls using privilege sets and custom menus... but I just don't feel this is as secure as I'd like it to be.

       

      If anyone has suggestions, they would be greatly appreciated.  Thanks! 

        • 1. Re: Limiting access to specific records...
          Jade
            

          jsmarvey wrote: 

           

          If anyone has suggestions, 


          I'm not able to test this right now so take this with a grain of salt.
          Step 1: Make a value list ("Users" ) of User names and include only related values starting from "Projects"  
          Step 2: Edit Privilege Set setting the Records: to "Custom privileges…" and Set Privileges: View to "Limited…".  Set the calculation for Records can be viewed when: to "PatternCount (ValueListItems( yourFileName ; Users ) ; userName ) > 0 "