Forum Discussion
janice88
Mar 16, 2025Copper Contributor
DB change of account
Our database jobs, such as full database backups, transaction log backups, system database backups, Reorg job , Update stats and few DB related jobs and task scheduler jobs for housekeeping the trac...
ItsBhatti
Mar 18, 2025Iron Contributor
To remove DB and SQL admin privileges without affecting your jobs, you need to:
Check Job Ownership: Ensure that the SQL jobs are owned by the account with admin rights, but also check that the necessary permissions are granted for executing jobs.
Grant Specific Permissions: Instead of full admin rights, assign the SQL Agent Operator or SQL Agent User roles to the account. These roles allow the account to run jobs without needing full admin privileges.
Test with a Non-Admin Account: Test the account with limited permissions on a test environment to confirm the jobs still run properly.
You should reach out to support to confirm the specific steps for your setuphttps://www.clean-tech.co.il/