Unanswered: Can a specific user be blocked using Application Roles
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
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.