cancel
Showing results for 
Search instead for 
Did you mean: 
Superhoop
Level 9

Registering a different ePO server

Hi All,

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 ?

Regards

Superhoop

0 Kudos
2 Replies
alexn
Level 14

Re: Registering a different ePO server

Five premission are required.

Write

Read

Insert

Delete

Copy

So make sure the assigned SQL user have these premissions.

0 Kudos
McAfee Employee

Re: Registering a different ePO server

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.

HTH -

Joe

0 Kudos