Skip navigation
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
391 Views 2 Replies Latest reply: May 3, 2013 12:26 PM by JoeBidgood RSS
Superhoop Apprentice 77 posts since
Dec 30, 2009
Currently Being Moderated

May 3, 2013 10:47 AM

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

  • alexn Veteran 722 posts since
    Aug 9, 2012
    Currently Being Moderated
    1. May 3, 2013 11:51 AM (in response to Superhoop)
    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.


    Post Timings: 6.00 AM to 3.00PM PDT
  • JoeBidgood McAfee SME 2,874 posts since
    Sep 11, 2009
    Currently Being Moderated
    2. May 3, 2013 12:26 PM (in response to Superhoop)
    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




    (Please post questions to the forum, as I am unable to respond to private messages. Thanks!)



More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 5 points
  • Helpful Answers - 3 points