Best Practice for MSDE User permissions

From: Steve (Steve_at_discussions.microsoft.com)
Date: 08/27/05


Date: Sat, 27 Aug 2005 03:05:04 -0700

Hi All

I am new to MSDE/SQL Server and need some guidance on best practices for
user permissions.

I have a VB6 program running in a bakery factory
The computer network is a peer to peer 3 computer network running WIndowsXP
MSDE runs on computer A and the data entry person runs my program on this
machine to enter daily orders for their customers

A manager needs to access the MSDE data from another computer for reporting
tasks and is not allowed to enter or modify data

I am sure I can't use Windows authentication as it is only a peer network.
Is this correct?

Should I create a new Login and set individual permissions on each table or
is it OK to use the sa account etc?

Any ideas appreciated

-- 
Regards
Steve