password protect sql views
-
hi guys, Any idea on how i can protect my sql 2005 view on a client site, in which others cannot see what the view does? been trying to look around on google, but have not found anything. thanks Anoop
-
hi guys, Any idea on how i can protect my sql 2005 view on a client site, in which others cannot see what the view does? been trying to look around on google, but have not found anything. thanks Anoop
Give the view a schema prefix eg ABSystems.ViewName and use SQL security to restrict access to the view. This will not stop a quality DBA but will slow down the average user. A DBA owns the database you are working on and as such will get access to your code somehow. I can think of 2 ways to get around this setup.
Never underestimate the power of human stupidity RAH