Thats great, thank you so much for your suggestions, but one morething, as bkelley told, if I give db_datareader, the user is able to have a readonly view to all...

Hi there,

Thank yo so much, i tried and it worked, however, i created an other user and used it instead of sa. if i create a oledb connection string, it...