Posted by Erland Sommarskog on 12/22/06 11:24

Pulpet (xyzt@op.pl) writes:
> I wrote some complicated functions (and stored procedures) in database
> at my work. System administrator (and every db user) can view codes
> (in Enterprise Manager for eg.). My employer needs periodic modifying
> of code and so I'm required to do it. But I can loose my job :)
> because users are able to modify code (althout they ware too lazy to
> create it by themselves).
>
> Is this possible to protect functions from view it?

I don't really know why you would prevent people from viewing your code,
least of all if they are in the same company.

But you should of course have all your code under version control, and
use the database as the storage for your code.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]