On 22 Jul 2005 06:24:44 -0700, "Simon Hayes" <sql@hayes.ch> wrote:

>If you're new to MSSQL, it would probably be a good idea to spend some
>time reviewing the security model - see "Managing Security" in Books
>Online, and also the resources here:
>
>http://www.microsoft.com/sql/techinf...y/default.mspx
>
>It's hard to be specific without knowing more about what the students
>will be developing, but if you install the latest servicepack (SP4),
>don't allow users to execute xp_cmdshell or create ActiveX jobs, and
>don't give them database owner privileges, that should prevent some of
>the more obvious abuses. The baseline security analyzer (see the link
>above) is also very useful for finding potential configuration issues.
>
>Simon

Cheers will do!
Paul