Restrict access to sync source data
- Denise McGettigan
You can restrict an administration user’s access to certain data. You might want to do this if you want to restrict administration users from being able to create and modify certain databases, or query the data in a database. For example, suppose you have both the Analytics and Financial Statements modules and you want to allow an administrator to modify and build the Analytics databases but NOT any of the Financial Statement databases. In other words, you might want to have an Admin user with NO access to financial data.
By default, the Administration permissions of Databases and Sync go hand-in-hand to allow users to access the Designer and Sync modules, and manage databases that are built from sync sources.
To restrict an administration user from accessing the data, add an owner to the corresponding sync source and lock that sync source as follows:
Click Administration> Sync sources.
Click the source’s name (blue link) to open its page, then click the Source tab.
Add an owner: Click in the Owners box and select one or more owners from the list. These are the users who you want to be able to access the sync source’s data.
Lock the sync source: Select Yes from the Is Locked list. This action locks the sync source’s data, so no one except for the designated owners can access it.
Enter a note to explain your action or add other information, if required.
Click Save. The results of this action are summarized below.
Now when other admin users view the sync sources, they can open the source to view its items but not query any of its data; only the owner can query the data.
Similarly, when other admin users open another database in Designer, the source item is not available; it only displays for the owner.
Other admin users cannot open the financial database in Designer; only the owner can do so. This ensures those other admin users have no way in which to view the underlying data.