How do I restrict Sage 300 CRE data from being viewed by specific people?

Solution

Using the security features contained within the Security Administration area of Sage 300 CRE, you have complete control over the specific tables that Office Connector users can query and update. Read and write access can be enabled or disabled for individual tables by identifying the security roles that should have access to them.

Task Security for ODBC

Office Connector relies on ODBC to read and write information and so the security settings that apply to ODBC will affect what users of Office Connector can or cannot access. A security administrator can follow these steps to grant or deny access to specific tables for selected roles:

Start Sage Desktop

Click the Tools menu and click Security Administration

Under Security Permissions by Type, click Tasks

Navigate to the ODBC node and expand it

Select Read Access or Write Access based on what you are wanting to limit and expand that node

Select a table you wish to restrict

Check the box for each security role that should have access to the data (or un-check the roles that should not have access)

Repeat these steps for each additional table you wish to restrict

Record Security

Record security can be used to restrict access to specific records in tables based on role. This level of security affects all areas of Sage 300 CRE (not just data that would be available via Office Connector). Enabling record-level security can also decrease performance. It is recommended that you seek consulting advice before activating this feature. The record-level security options are found in the following area.

Start Sage Desktop

Click the Tools menu and click Security Administration

Under Security Permissions by Type, click Records

Need Assistance?

The security features of Sage 300 CRE are not supported by the Office Connector support team since these features relate to the core application. For additional guidance or help with security-related questions, contact your Sage Timberline Office support representative, seek guidance from a qualified consultant, or review the help resources pertaining to security.