I want to give my database to the client to install on their server.
However, I want to deny the client rights to see the tables and stored procedures and also want to restrict that database to run from a single IP address.
How do I stop the user viewing the database tables even though database is present on their server?
We want to give the application to run on their own servers, but we don't want to show the tables and stored procedures. They are also not supposed to make any modifications to the database. Is this possible?
Perhaps can we encrypt database credentials in the web.config file?