i developed winforms application sql server 2008 r2 database 1 friends.
when deployed & installed on friend's pc; software shows database file. if open file in sql server, can able watch sql queries, tbl structures etc.
i want hide clients.
how can this?
i search of software on internet. when installed on pc; not showing me database file. how it?
please me.
if application , database both deployed on friend's pc, there's nothing can block him/her getting database.
there no feature in sql server blocks schema view authorized user (e.g. admin) , if own machine, can present admin sql server in multiple ways if not added admin role or given sa account access. can setup hurdles putting in stored procedures encrypting sp it's small hurdle, not wall.
this not unique sql server, same issues apply pretty rdbms in market. if own box, it's not hard db contents. software vendors have been trying decades , give , protect ip legally instead. that's no consolation reality.
if using service azure viable, can host app in azure , database can azure sql db or regular sql server in vm. i'd recommend former if feature set , surface area work you; it's not identical sql server box product you're accustomed to. however, far less work manage , secure. app in azure, friend , clients access via browser , never have direct access database. if app installed locally on friend's or clients' machines, it's easy design app such can access data , nothing else.
Comments
Post a Comment