You can use Sync to 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. 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 module and all the sync sources.
To restrict a user from accessing the Designer module for a certain database, you need to add an owner to the corresponding sync source and lock that sync source. Continuing with the example above, suppose you want to restrict access to your financial database:
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.
When other admin users now view the sync sources, they can open the Financial Statements source to view its items but not query any of its data. Only the owner can access the data.
Similarly, in Designer, the Financial Statements source item is available to the owner only.
