Example: Set Up Access Rules for Regional Manager
Create access rules for a regional manager.
The manager leads all stores in the northern regions of the country. The manager has contributor permissions already, and you must create access rules that enable the manager to:
- View the Inventory account at all levels.
- Edit all accounts, including salary details, at the levels in their regions.
- Have no access to prospect products, like Scarves.
Your model includes:
Levels | General Ledger Accounts | Personnel Modeled Sheet | Product Custom Dimension |
|---|---|---|---|
HQ
| Expenses
Revenue
| Information about the sheet:
| T-shirts Tank Tops Sweaters Jackets Hats Gloves Scarves (prospect product for planning only) |
- Assign theContributorpermission set to the regional manager. See Example: Create a Permission Set and Assign to Contributors.
- Save your access rules in a spreadsheet calledNew Access Rules. You have already created access rules for admin, the CEO, the Financial Analyst, and the VP of Sales.
- Security:Userspermission.
- Open theNew Access Rulesspreadsheet from your computer folder.
- As you complete the columns of the first blank row, consider:
Option Bezeichnung Access TypeEnterFull View.UsernameEnternregion@company.com.Level (Grant)Enter(+).Account (Grant)EnterInventoryto grant full view access to only this account at all levels.Product (Grant All Except)EnterScarvesto grant access to all products exceptScarvesat the Inventory account and all levels. - As you complete the columns of the next blank row, consider:
Option Bezeichnung Access TypeEnterEdit.UsernameEnternregions@company.com.Level (Grant)EnterSales NE. In the cell below this entry, enterSales NW. Always enter additional levels in separate rows.Account (Grant All Except)Enter(+)to grant edit access to all accounts at theSales NWandSales NElevels.Product (Grant All Except)EnterScarvesto restrict the manager from seeingScarvesin the model. - Save the sheet.
- Return to .
- From the toolbar, clickImport.
- SelectUpdate and Append.
- Click the cloud to upload theNew Access Rulesspreadsheet from your computer folder.
- ClickDone.