Error : You do not have the permission to run 'SYS.TRACES'

recrash

Hello,

I'm using the SQL Source Control 4 on shared database, and I want to visualize clarify 'Last changed by' column to identify who are charged in those objects.
So, I followed all the steps which was guided in the documents(http://documentation.red-gate.com/displ ... +databases).

but there is error when I turned the commit changes, SQL Source Control tab.

"The user does not have permission to perform this action.
You do not have permission to run 'SYS.TRACES'.

Before I write this, I googled this error to solve and try to solve the error like
granting my account to tempdb, and changelog as follow,
(viewtopic.php?t=16548)

1. get the dbo.owner to user

2.
use tempdb

GRANT EXECUTE TO <user>
GRANT ALTER TO <user>

use Changelog

GRANT EXECUTE TO <user>
GRANT ALTER TO <user>

But, It still doesn't work. What can I do? Please help me. Thanks.

Sergio R

Hi,

I am sorry that you are having issues when using SQL Source Control.

Please try the following:

GRANT ALTER TRACE TO <user>

https://msdn.microsoft.com/en-us/library/cc293611.aspx

Also make sure that you have the user permissions set as per the following document:
http://documentation.red-gate.com/displ ... ermissions

Thank you,