Give right to user in SQL Server 2005.
Posted on 2009-06-27
Hi experts !
Im using SQL Server 2005 SP3. Im log with limit user via SQL Server autentaction. But now, I want to execute this :
Select P.spid, p.Hostname, P.Program_Name, P.Loginame, C.client_net_address, c.client_tcp_port
From master.dbo.sysprocesses P Left Join sys.dm_exec_connections C on P.spid = c.session_id
And probably will want to be able to do kill spid. Other question: how is exatly synatcis of kill spis ?
The main question is: is there way to give right only to these master.dbo.sysprocesses, sys.dm_exec_connections and kill spid ? I do not want to give more right that is nesseasry to this user & with give him role . I need SQL script that do this.