Method Community

 

Controlling Permissions of a Vendor on a PER vendor basis.

Last post 01-15-2015 2:58 PM by Method_Justin. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 01-15-2015 10:03 AM

    Controlling Permissions of a Vendor on a PER vendor basis.

    Hello All, 

    Currently, I'm looking for a way to control permissions on a per vendor basis instead of "X user has access to vendors, and everything in vendors". 

    The main reasoning behind this is our high end scrap clientel is very important to us and I do not want employees or anyone else having access to this data by "accident". 

    If I could control access on a per vendor basis this would solve my problem without having to create a duplicate vendors tab then control permissions from there. 

    I would much rather still have google gadget functionality then in method control who has access to that vendor on a per vendor basis. 

    Has anyone ever tried to do anything similar to this? 

    Any suggestions? 

    Thanks in advance, 

    RK

  • 01-15-2015 2:58 PM In reply to

    Re: Controlling Permissions of a Vendor on a PER vendor basis.

    Answer

    Hi RK,

    Since this would be a many-to-many relationship, you would have to create a table to detail the relationship. I would most likely create an "AssignedTo" table with two dropdowns, one for Vendor (linked to the Vendor table) and one for User (linked to the User table). You could then enter the relationships into the table, and use that table to filter your Vendor List.

    Hope this helps.

    - Justin

    Justin Henderiks
    Technical Sales Specialist
    Method Integration Inc.
    Toll Free: 1.888.925.6238
    Local and overseas: 416.847.0400
    Fax: 416.640.6027
    E-mail: j.henderiks@method.me
Page 1 of 1 (2 items)