Sometimes as a DBA, you come across a situation where you need to give access to a non sysadmin user to run profiler on a particular SQL server.
If you try to run the profiler using the user who does not have sysadmin access then you will get the below error.
Here is the solution how to grant access to a non sysadmin user to run profiler.
Using Query:
Using SSMS:
Note: The Granter should be a sysadmin user.
If you try to run the profiler using the user who does not have sysadmin access then you will get the below error.
Here is the solution how to grant access to a non sysadmin user to run profiler.
Using Query:
-- To Grant access to a Windows Login USE master; GRANT ALTER TRACE TO [Domain\WindowsLogin] -- To Grant access to a SQL Login USE master; GRANT ALTER TRACE TO [SQL User]
Using SSMS:
- Expand the Server in object Explorer
- Expand "Security" folder and then "logins"
- Right-Click on the login to which you need to give access and then go to "Properties" of that login
- Go to "Securables" Tab
- Select the server you want to add the permission
- In the "Permission for <Server Name>" block, click on "Grant" check box for "Alter Trace" and click "OK"
- Once this is completed, the permission should appear in the "Effective" Tab
Note: The Granter should be a sysadmin user.
3 comments:
Perfect one..Its working.
spot on!
Mua vé tại Aivivu, tham khảo
gia ve may bay di my
vé bay từ mỹ về việt nam
các chuyến bay sang nhật có bị cấm không
các chuyến bay từ đức về việt nam hôm nay
lịch bay từ canada về việt nam
giá vé máy bay từ hàn quốc về việt nam
khách sạn cách ly hà nội
vé máy bay cho chuyên gia nước ngoài
Post a Comment