January 6, 2006 at 7:01 am
I gave a user the process admin role to be able to kill his processes on the server. But the user dont see any processes with EM. How can we solve this?
January 6, 2006 at 7:18 am
I don't know why the user still cannot see the processes in EM, but you can let him run sp_who or sp_who2, or select * FROM master..sysprocesses.
Check the login column for the user.
January 6, 2006 at 7:32 am
Check the permissions on a stored procedure in the master database: sp_MSset_current_activity. This is what Enterprise Manager calls to get that information. Permissions should be set where the public role has been granted Execute rights on the stored procedure.
K. Brian Kelley
@kbriankelley
January 6, 2006 at 7:52 am
I have checked bkelley says, the public role has exec permissions on the sp.
Strange is that on the dev sql server, the same user can see the processes. But not on the production server.
January 6, 2006 at 8:05 am
Run a Profiler trace of the production server. Make sure to toggle the Audit Object Permission Event with the Success data column. Have the user try and view Current Activity and see if you see the execution of the stored procedure. You should also see an Audit Object Permission Event entry fire with a value of 1 on Success. However, this will confirm whether or not the user is successfully executing the stored procedure.
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply