Question
Restrict Guest Users Access, especially to Save As feature
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.
+17Hi 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.
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.
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.
+17Hi 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.
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.
Hi Evan,
"Your other users should still be able to use the Import/Export link, they just loose access to that more handy Save as Spreadsheet"
In response to above, this is what I tried -
App Settings: not checked
Permissions: Edit App Structure: Not checked
UI: Imp/Export: Not checked
Yes Save as Spreadsheet is disabled (good), and Import/Export shows (ok), and Export is grayed out/disabled (doesn't work), and Import is Enabled (not good for my app).
Any advice?
"Your other users should still be able to use the Import/Export link, they just loose access to that more handy Save as Spreadsheet"
In response to above, this is what I tried -
App Settings: not checked
Permissions: Edit App Structure: Not checked
UI: Imp/Export: Not checked
Yes Save as Spreadsheet is disabled (good), and Import/Export shows (ok), and Export is grayed out/disabled (doesn't work), and Import is Enabled (not good for my app).
Any advice?
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.