Thanks a lot for your time, i will try it and see how it goes.

I understand a Windows group will act as a login. So once a windows group is created, if I strip it from all server roles, will my application be able...

This is what I have

Database: MainDB (lets say)

I have created a role in MainDB called ExecuteOnly which can only execute SPs

Login: Test\User1mapped to MainDB

User: TestUser for the Login:Test\User1

The Test\User1 is...

Hello again

I cant use the login created from the above written procedures to access the database unless i make it sysadmin. If I make it sysadmin the login will be...

Thank you very much!