About Data Access

Different members of your team should see different information. For example, say you use QuickBase to run a car dealership. Salespeople need to see their leads. Your service people need to see customer repair appointments. Service workers have no interest in seeing sales leads, but it's no big deal if they do. However, neither group should ever be able to see your employee table's salary field. That info's for your accountant's eyes only. So how do you set up your QuickBase application to meet all these requirements?

Data access guidelines: choosing the right tool for the job

You can easily hide values from (or show specific values to) any user of your application. QuickBase offers you two features to control what users see: roles and reports. The one you use depends upon what you're trying to do.

In order to decide which tool's right for the job, answer this simple question:

  Is your goal to secure data or to focus attention on a particular set of records?

Why you should follow these guidelines

DO NOT try to use reports to control access to sensitive fields or records, you'll compromise the security of your data. For instance, even if you don't include the salary field in any reports you've saved, users can still create their own report that includes this field. However, if you use role permissions to deny access, users in these roles won't even know this field exists. If your application contains confidential information, put QuickBase's powerful access controls to use. (Read more.)

Likewise, if you implement role permission controls merely to deliver customized information, you'll make your application unnecessarily complex and difficult to manage. It's like using a sledgehammer to crack open a nut. Reports are much more versatile and effective filters than permission restrictions.

Related Topics


This page refers to an older version of QuickBase. Online help is now located at http://www.quickbase.com/user-assistance/default.html.


Return to top   

© 1999-2013 Intuit Inc. All rights reserved. Legal Notices.