Thanks for the link and i have already checked it but i am trying to see if there is chance to mis utilise or tweak something to do more...

I am trying to create a stored procedure where in i can give option to one of my developer to KILL sql sessions on a developmenet server. how would i...

Can non sys admin be given the previalge to KILL other processess, if so what would be the best method?

NO, it doesnt work that way. I still get the error below

Here is the result

dboempssn

this proc runs ok when a sysadmin or security admin executes it but not others which is where iam trying to get.

Can someone please tell me if this is really possible or not ?

thats a good reply but that guy planning for architect as that would get more pay for him hoping that he would minise day to day activites and concentrate more...

Ohh ok I got it.

I have to remove built in group in SQL Server to restrict users in the administrator group to prohibit from sql server, right?

Does that mean If a user is not in Built in admin group and but in local admin group that user can not have access to SQL Server?

Sorry I am not clear with this, if i am adding a user to Administrators group on windows do you mean that user will not have sysadmin access on sql...

But i think Idera is very much expensive when comapred to Apex, right?

by the way are there any tools from Quest or Redgate for this purpose?

Does these tools track who and when

1. updated table

2. updated column

3. any alter to any objects

4. reading a database (would like to know last usage of the db(read)

5. deleted object

6.logged...

any scripts to help this from the forum members?

any idea on how to give previalges to a user so that user can deny permissions for others on a table through a stored proc?

is there a way to impersonate...