Posted by Greg D. Moore \(Strider\) on 12/22/06 14:51

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns98A17E44A56E4Yazorman@127.0.0.1...
> 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.

Also, it sounds like the viewing isn't the problem, it's the users able to
modify the code.

Simple answer, make sure they don't have rights to make such changes.

Generally as a first pass, I try to lock users down to db_datareader and if
necessary db_datawriter.

That may solve your problem.


>
>
> --
> 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]