KB485833: Restrict write-back access of Calendar Builder Report
Write back access of calendar builder report can be restricted, if required, using Strategy's Connection Mapping for a Project.
Description
Providing write-back access to a Strategy user can be a challenge. This challenge can be solved solved by using using Strategy's Connection Mapping for Project. Using connection mapping admins can restrict the write-back access to only limited admin users.
Steps to apply Connection Mapping
Create a user group for writing back to warehouse with full admin privileges, example: Admins_Write_Back
Create a Database login with write-back access, example: WritebackLogin
Create another Database login with read-only access, example: ReadOnlyuser
Create a connection mapping in the Project properties with only Admins_Write_Back user group mapped to WritebackLogin and everyone mapped to ReadOnlyuser
Conclusion
Even through the calendar builder report requires the write-back access to the warehouse DB, it does not have security challenge, since using connection-mapping, none of the non-admin users will be ever able to write back to the warehouse.
.jpg&w=3840&q=100)
