Quick one, I have a master ePO and wish to connect other ePO servers to it. Could I use an SQL account with read only permissions in an attempt to reduce the risk or would I need full DB owner rights for the roll up tasks etc to work ?
It depends on the type of rollup that you're doing, but in reality you're going to need at least dbo. This is because a lot of the rollup processes need to run stored procedures, which needs Execute privileges. If you only have Read, then I would imagine some classes of rollup reports will fail.
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.
Community Help Hub
New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.