Winforms and SQL server windows authentication

120 Views Asked by At

Is possible to have windows authentication with connect, read and write rights, but without possibility the user has rights to connect with SQL Management Studio? I want the user has rights to connect and execute queries with his own domain username from an application, but not to connect from SQL Management Studio.

1

There are 1 best solutions below

0
On

The only solution which I have succeeded to find is this: Define login only with rights to execute stored procedures, then move all queries to SP. By this way you can connect with SQL Management Studio but cannot list any table or change anything or even see the table/sp names.