0

Users

hi, I have a database shared with several users.

I would like to protect the privacy of each single user, means not disclose its own work on the platform at the other.

What is the best way to do it?

 

Thanks in advance.

Max

14 replies

null
    • Mconneen
    • 5 yrs ago
    • Reported - view

    This is currently possible by placing the following into the "Is Readable" formula.. 

    _cu = user()

    This is called out in the user manaual here.. 

    https://ninoxdb.de/en/manual/user-management-identities-and-rights/user-management-identities-and-rights

    then search for "Readable If"

    readableIf

    • maxvalentino
    • 5 yrs ago
    • Reported - view

    many thanks, this formula allowed to read the table or the records?

    What if I would like to share the table with all the users but I would like to allow to read only the records each users created?

    • Mconneen
    • 5 yrs ago
    • Reported - view

    yes.. while the manual says "table".. in my testing, it is referring to the table ROW.   So the above logic will PREVENT a user from seeing a row they did not create. 

    • valentino_max
    • 5 yrs ago
    • Reported - view

    Hi many  many thanks for your support, you were right and the formula works properly.

    What if I would like to apply it at a single field record?

    • Mconneen
    • 5 yrs ago
    • Reported - view

    Similar logic.. put it in the "Display field only, if:" formula. 

    displayIf

    • maxvalentino
    • 5 yrs ago
    • Reported - view

    Thanks a lot, this about the formula field, and about the choice field?

    • maxvalentino
    • 5 yrs ago
    • Reported - view

    sorry, got it and solve it, thanks.

    as administrator could I have a full disclosure of teh records present in the db?

    • valentino_max
    • 5 yrs ago
    • Reported - view

    applying the _cu = user() formula at the "Display field only, if:" field this field disappear from the db structure if I access as a different user.

    Is it possible to save the structure of the db and to hide only the record?

    • Alexander_Koenig
    • 5 yrs ago
    • Reported - view

    try:

    userIsAdmin()

    • valentino_max
    • 5 yrs ago
    • Reported - view

    hi Alex, I tried:

    1. add the userIsAdmin() in the "Display field only, if:" alone, before and after the _cu=user() using ; between the first and the second part of the formula

    2. substitute the _cu=user() with _cu=userIsAdmin

    no positive result. any other idea?

    • Mconneen.1
    • 5 yrs ago
    • Reported - view

    This seems to work for me. 
    user() = _cu or userIsAdmin()

    • valentino_max
    • 5 yrs ago
    • Reported - view

    Many thanks Mike, it works for me too.

    What if I would like to see who create the record?

    • Mconneen
    • 5 yrs ago
    • Reported - view

    create a formula and return _cu or 'Created by'

    • maxvalentino
    • 5 yrs ago
    • Reported - view

    You are amazing, many thanks

Content aside

  • 5 yrs agoLast active
  • 14Replies
  • 4850Views