What are the challenges you face when working across database platforms? Take the survey
Options

Safe/Minimum permissions

Hi,

We are attempting to use DLM Automation on our TeamCity server using a separate SQL server for the temporary database.
Initially this was failing as DLM would try to set "trustworthy" on since the service account was not an administrative account.

I've since spoken with our central DBAs and investigated this settings. We are not happy giving the CI service account such elevated permissions since it presents such a large security problem.

What are the minimum permissions for SQL account which "Redgate DLM Automation Build" is using?
Specifically, I want to avoid giving the user sysadmin permissions.

Thanks in advance!
Tagged:

Answers

Sign In or Register to comment.