3 Replies Latest reply on Jan 20, 2014 3:19 PM by philmodjunk

    Filemaker 13 permissions Sets

    BrandonEast

      Title

      Filemaker 13 permissions Sets

      Post

      Here is our filemaker setup:

            

      One Data file

            

      Multiple interface files for various business needs such as:

            

      Inventory

      Assets

      Projects

      Purchase Orders

      Clients

      Etc…


            

      I would like to use a table to store user information such as username and password, I would also like to have another related table to define user groups. Based on which groups a user belongs to they would have access to those tables specified in a permissions field. Such as Inventory Create/Read/Update/Delete, Asset Create/Read/Update/Delete and so on. Where Create/Read/Update/Delete are checkboxes.

            

      So a user would have the ability to belong to one or more groups and each group would have the permissions to perform various Create/Read/Update/Delete actions on each table.

            

      I assume I cannot use filemakers privilege sets since a user can only belong to one privilege set per user.


      Is there a way to do this in filemaker 13?

            

      -Brandon-

        • 1. Re: Filemaker 13 permissions Sets
          philmodjunk

               It may be possible. You might set up two accounts, each with a different privilege set for the same users. A script could use Re-LogIn to automatically log the user in under a different account name/privilege set when moving to a different part of the system.

               Or you could define privilege sets that combine permissions for multiple groups to use with users that are members of more than one group.

               

          One Data file

               

          Multiple interface files for various business needs such as:

               I'm familiar with the data separation concept, but such a large number of Multiple interface files instead of a single interface file would seem to complicate the design, maintenance and management of your database by quite a bit for little gain over using a single interface file.

          • 2. Re: Filemaker 13 permissions Sets
            BrandonEast

                 If you were doing a Database for over 150+ users with over 30+ different permission sets. What method would you go about making this happen the easiest and most manageable way.

            • 3. Re: Filemaker 13 permissions Sets
              philmodjunk

              Easiest would be a long way from easy. Without putting on my consultant hat and making a detailed survey of your database, your user base and how they need to work with the database, it would be hard to say and the final solution may also use external server authentication.