{{theTime}}

Search This Blog

Total Pageviews

Grant ALTER TRACE permission in SQL Server

Now if I try to create a trace with “testuser” credentials then I will get the following error message saying that the user does not adequate permissions to run trace.

Now lets see how to give the user ALTER TRACE permission:

SSMS – Under Security tab –> Logins –> Right click the login name to modify the properties –> Securables tab –>Click Search –> Select the instance you want to add the permissions to –> Under Explicit tab –> Select the GRANT Check box against ALTER trace permission. –> Click OK

Now lets try to create trace with the “testuser” login:

Yes we can create the trace as “testuser” . So this explains how we


can give ALTER TRACE permission to a login.

No comments:

Could not find method signingConfigs() for arguments

Could not find method signingConfigs() for arguments [build_5dw7nwfc8ibd8sagvx4p79x1u$_run_closure5@13e86039] on root project 'android&#...