The user that I am taking this permission away from do have the sysadmin server role so I am going to revoke that....Problem solved

Thank you

I do not think so. SUSER_NAME() does not have a restriction related to Database Users. The function is poorly named. It returns Server Login information.[/quote]

What if rather than SUSER_Name()= I...

Yes but to restict access to one specific login they would have to be in the master correct? What I am looking to do is allow my group to...

Im thinking that the Resource Governor is a great Idea Im reading up on it now and it sounds like a great tool for what I am looking to do....

Would you know how to go about setting this up. I have been looking in the user policy for sometime now but havent found anything specific to revoke Select...

I am looking to

1.Prevent ability to perform a select *, or if they are doing a select * the query must have a where clause

2.If the query runs longer...