Best Practice for MSDE User permissions
From: Steve (Steve_at_discussions.microsoft.com)
Date: 08/27/05
- Next message: Dan Guzman: "Re: Best Practice for MSDE User permissions"
- Previous message: Rene: "Re: Confused about dbo"
- Next in thread: Dan Guzman: "Re: Best Practice for MSDE User permissions"
- Reply: Dan Guzman: "Re: Best Practice for MSDE User permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
- Next message: Dan Guzman: "Re: Best Practice for MSDE User permissions"
- Previous message: Rene: "Re: Confused about dbo"
- Next in thread: Dan Guzman: "Re: Best Practice for MSDE User permissions"
- Reply: Dan Guzman: "Re: Best Practice for MSDE User permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]