Description
Every morning after the data is copied by COINS from Live to CPlive environments we reset the super user list ourselves (this action is automatically done by Mosaic). This is so our project team has elevated permissions to aid with support and development.
If for some reason CPlive isn't available or has to be recovered later in the day, then the users will need to be reset again.
Process
The Vistry Development & Quality team, in sql database 'COINS_integration' have a table of users and the groups that are to be set. This table is 'dbo.Permissions'. Amendments and new requests should be directed to the development team.
We can manually apply the changes through using Mosaic dashboard
URL Mosaic | Live
In Mosaic select Tools > Services
Just choose 'Execute' on the COINS Copy of Live Permissions line