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

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


      Product Table


      ProductIDNumberIndexed, Auto-enter serial
      Product Name
      Product Lot No.
      Product Code
      Quantity Received
      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