0

Maintenance mode

Hello,

In the cloud version, is it possible to put a "maintenance mode". So that other users cannot access the database while the admin makes some changes or updates?

Thanks in advance for your feedback and have a nice day.

David W.

2 replies

null
    • Mconneen
    • 4 yrs ago
    • Reported - view

    @David.. That is a greate use case.     There are a few strategies ..

    In the database, go into admin mode (the wrench) and navigate to Security .. and set the open database to Admin role only.   This will prevent others from even seeing the database within their team screen.   As such, you will need to train your users that if they do NOT see the database.. it is in mainteance mode. :) 

    adminOnly

     

    Another strategy is to create a Configuration table (or call it what ever you want) .. permit only the admin to create/update/delete rows so others do not see the table..  and add a row to set "Maintenance" to true..   Then, within each tables "writeable if" .. check to see if the user hasRole("Admin"), if so.. return true  else check this flag and if set to Yes.. return false, else return true.. Bascially .. this will flip the table to readonly for all users except the admin. 

    config

    I created a global function called maintMode() which determines if the table is in a writeable state or not. 

    function

     

    Then in each table.. I call the function. 

    table

    **NOTE **   This worked great in the Ninox App (Mac OS X), but does NOT seem to work when accessing it via the browser.. I have a note into support asking why..

    • David_WILLOX
    • 4 yrs ago
    • Reported - view

    Thanks for the usefull and complete feedback :-)

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 915Views