Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Installation Requirements: Elevated Access Requirements

What are the minimum security grants required to run DBAmp? Does it require an SA id for SQL, local admin on Windows, or changes to the default SQL Server Surface Configuration (i.e. xp_cmdshell, .NET integrations, COM automation, etc)?
1 person has
this question
+1
Reply
  • Yes. The DBAmp Stored Procedures require xp_cmdshell access. You can establish this for non-sa users using the SQL Server xp_cmdshell proxy account. See the SQL Server doc for full instructions on setting this up.

    Note that there may be many users who select against the local tables that DBAmp creates. Most of these users do no need to run the DBAmp stored procedures. Normally, companies setup a specific user that is the owner of the jobs that run the DBAmp stored procs. It is this specific user that needs DBOwner on the database where the local tables are stored AND xp_cmdshell access.

    I am happy to discuss further via a web meeting. Send an email to support@forceamp.com .
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited

  • Thanks for the information Bill Emerson. I tested this specific configuration against one of our databases that uses the DBAmp stored procedures and it worked. Previously we had the DBAmp batch running using a standard SQL logon that was assigned to the sysadmin role. This configuration allows us to avoid using that very powerful role and also limits what can be done under this account using xp_cmdshell directly (to the access grants that the domain account has been granted, instead of running under the process id of the SQL server).
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited