Restrict Guest Users Access, especially to Save As feature

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
We have given view access to users that are part of client company but realize that they can Save As Spreadsheet and take all the data with them if they wanted. How do I prevent the Save As Spreadsheet. How can I give them total View only access so they cannot print or save reports that they are able to view.
Photo of Ruby Kapil

Ruby Kapil

  • 816 Points 500 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,774 Points 5k badge 2x thumb
Hi Ruby, 

It is possible to disable that option to save as spreadsheet for all non Admins in an application. This can be found by accessing the Application Settings and going into the App Settings header. Within that page you will find a section on Security options and specifically a checkbox for "Allow users who are not administrators to export data". When this is unchecked users who are not Admins will not get the option to save as spreadsheet. What can be confusing with that is if you are the Application Manager even if you test as that user or role you can still access Save as Spreadsheet as QB does recognize your Application Manager status. If you have another user test that role, or make use of a dummy user, you should see that the save as spreadsheet option does disappear for roles that do not have Admin permissions. I hope this information is helpful. 
Photo of Ruby Kapil

Ruby Kapil

  • 816 Points 500 badge 2x thumb
Hi Evan, I did test the global feature of allow non admin to export data. So I'm wondering, I have a set of Standard set of users that enter data into my app and also save as spreadsheet. I have another set of Guest users that only need to see certain reports but should not be able to Save As. For my Standard set of users, could I give them some type of Admin-Jr role and use the global disable Save As feature to restrict the Guest users? But how do I set up the Admin-Jr role. I tried copying the Admin role, but it shows as Basic not as Admin. Not sure how to do this. I'm hoping I can scale back the Admin-Jr role to mimic the Standard user role I currently have. Thanks.
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,774 Points 5k badge 2x thumb
Hi Ruby,

To be counted as an Admin rule they have to have the permissions to edit the application structure checkbox checked. That is what differentiates an Admin and Basic role. Unfortunately, when that save as spreadsheet is disabled for non admins that option does get restricted. Your other users should still be able to use the Import/Export link, they just loose access to that more handy Save as Spreadsheet. The general principle being that users with those permissions could already take a screenshot or copy and paste the data directly from Quick Base so we usually take view permissions to be basic access permissions.