Hi,

I have a DB that have an Application Role that is being used by the client application. What I need to do is run a store procedure in the client app. that blocks user01 from accesing some specific tables when a process is run, the store procedure looks something like this:

DENY INSERT, UPDATE, DELETE On TableName To user01
RUNPROCESS
ALLOW INSERT, UPDATE, DELETE On TableName to user01

Well the problem is that the DENY command is not blocking the user. I think it's happening because the Application Role gives the app. role permissions to the user when he uses the sp_setapprole store procedure and these permissions can't be changed.

Does any one knows a way I could achive this?

Thanks,

Alex.