How to GRANT ALTER TRACE permission in SQL Server 2005/2008?
If user don't have profiler run permission, though he has dbowner access because profiler is a server level so to give profiler access permission follow below any one procedure.When the user is not having 'sa' permission and don't have Alter trace permission, he can't run profiler.
Method 1: By using GUI.
1) Connect the server in SSMS(SQL Server Management Studio)
2) Go to Object Explorer
3) expand the Security folder
4) expand the Logins folder
5) Right click Login name and select properties
6) Select securables tab
7) Click search
8) Select The server 'server name'
9) Click OK
10) Select permission Alter trace
11)Select Grant
12)Click OK.
3) expand the Security folder
4) expand the Logins folder
5) Right click Login name and select properties
6) Select securables tab
7) Click search
8) Select The server 'server name'
9) Click OK
10) Select permission Alter trace
11)Select Grant
12)Click OK.
Method 2: By using SQL script.
use master
GRANT ALTER TRACE TO [Username]
GRANT ALTER TRACE TO [Username]
How to remove ALTER TRACE permission.
To revoke the ALTER TRACE permission from the user follow below any one of the methods.
Method 1:By using GUI.
1) Connect the server in SSMS(SQL Server Management Studio).
2) Go to Object Explorer
3) Select and expand the Security folder
4) Select and expand the Logins folder
5) Right click Login name and select properties
6) Select securables tab
7) Click search
8) Select The server 'servername'
9) Click OK
10) Select permission Alter trace
11)unselect Grant permission
12)Click OK.
3) Select and expand the Security folder
4) Select and expand the Logins folder
5) Right click Login name and select properties
6) Select securables tab
7) Click search
8) Select The server 'servername'
9) Click OK
10) Select permission Alter trace
11)unselect Grant permission
12)Click OK.
Method 2: By using SQL script.
use master
REVOKE ALTER TRACE FROM [username]
No comments:
Post a Comment