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
    • 6 yrs agoTue, October 9, 2018 at 7:34 PM UTC
    • 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
    • 6 yrs agoTue, October 9, 2018 at 8:28 PM UTC
    • 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
    • 6 yrs agoTue, October 9, 2018 at 8:41 PM UTC
    • 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
    • 6 yrs agoWed, October 10, 2018 at 8:59 AM UTC
    • 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
    • 6 yrs agoWed, October 10, 2018 at 12:13 PM UTC
    • Reported - view

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

    displayIf

    • maxvalentino
    • 6 yrs agoWed, October 10, 2018 at 1:05 PM UTC
    • Reported - view

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

    • maxvalentino
    • 6 yrs agoWed, October 10, 2018 at 1:38 PM UTC
    • 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
    • 6 yrs agoWed, October 10, 2018 at 1:49 PM UTC
    • 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
    • 6 yrs agoThu, October 11, 2018 at 3:50 PM UTC
    • Reported - view

    try:

    userIsAdmin()

    • valentino_max
    • 6 yrs agoThu, October 11, 2018 at 4:19 PM UTC
    • 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
    • 6 yrs agoThu, October 11, 2018 at 5:52 PM UTC
    • Reported - view

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

    • valentino_max
    • 6 yrs agoThu, October 11, 2018 at 6:28 PM UTC
    • Reported - view

    Many thanks Mike, it works for me too.

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

    • Mconneen
    • 6 yrs agoThu, October 11, 2018 at 7:04 PM UTC
    • Reported - view

    create a formula and return _cu or 'Created by'

    • maxvalentino
    • 6 yrs agoThu, October 11, 2018 at 8:08 PM UTC
    • Reported - view

    You are amazing, many thanks

Login to reply

Content aside

Categories

View all topics
  • 6 yrs agoThu, October 11, 2018 at 8:08 PM UTCLast active
  • 14Replies
  • 4873Views