1 2 Previous Next 18 Replies Latest reply on Aug 3, 2015 7:27 AM by nodisorder

    Record Access

      Hi All,

       

      I'm trying to set up an privilege set that a user will see only his/her created record on the database. I have two Tables Users Table and Product Table

       

      My Users Table Fields Information

      FieldsTypeComments
      UserIDNumberIndexed, Auto-enter serial
      AccountNameText
      CreationAccountTextCreation Account Name, Can't Modify
      First NameText
      Last NameText
      FullNameCalculationFirstName & " " & TextStyleAdd(LastName; Bold)

       

      Product Table

       

      FieldsTypeComments
      ProductIDNumberIndexed, Auto-enter serial
      Products_UsersIDText
      Product Name
      Product Lot No.
      Product Code
      Quantity Received
      Supplier
      Received Date

       

      My Two tables are connected by UserID  = Products_UsersID

       

      I Created a Privilege Set Which I called Limited

       

      This is What I set Up

       

      Privilege Set Name (Limited)Description
      Records (Custom Privilege)
      Layouts (All Modifiable)
      Value Lists (All Modifiable)
      Scripts (All Modifiable)

       

      Table NameViewEditCreateDeleteField Access
      Users -----
      ProductsLimited ( IsEmpty ( Users::AccountName ) or Users::AccountName = Get ( AccountName )IsEmpty ( Users::AccountName ) or Users::AccountName = Get ( AccountName )Yes-all
      [Any New Table]----none

       

      Im trying to Log in to my Account Rosalie but not allowing me to create a record to my Product Table.

       

      Please find attached file for your reference.

       

      Thank you.

        1 2 Previous Next