Are you talking about SQL Security here, or is this application security?

Answer to your question. Yes, it is defined in the application. Enforcing the same security level even if the...

Thanks for your reply.

It is very much doable with stored proc. But I am planning to call in a view and view will be given to the users. Users...