Re: Does my Windows service need table permissions?
- From: "Norman Yuan" <FakeName@xxxxxxxxxxxxx>
- Date: Tue, 15 Sep 2009 19:41:45 -0700
What name of your Windows service app is does not matter, what user account is used to run the Windows service app matters. The account that runs the service can be local machince account (system, local service, network service...) or local user account, or domain user account. That account must be granted access to the SQL Server and the permission to run the SP.
"Mark" <mkhueb@xxxxxxxxx> wrote in message news:%23xUxyDmNKHA.1268@xxxxxxxxxxxxxxxxxxxxxxx
I have a Windows service that executes a stored procedure. The stored procedure updates or inserts records in a SQL Server 2005 table. A special user, PollX, was created for this database having a dbo role. I added PollX to the permissions of the stored procedure with Control, Execute, and Take Ownership privledges. Currently PollX has been added to the permissons of the table and the Windows service is running without problems. The name of my Windows service is PollX too. Do I really need to add PollX to the permissions of the table in order for the Windows service to be able to make updates to this table without running into security problems? I suspect that I don't. I'm confused about what permissions are needed in order for my Windows service to execute the stored procedure and whether the name of this SQL Server special user needs to be the same name as my Windows service. Any advice about this would be appreciated. Thanks in advance!
.
- References:
- Prev by Date: Re: Select (2+3+8+5+8+3+98+6+2) as Test1, (Test1+4) as Test2
- Next by Date: Re: Bulk insert stops after 438 rows
- Previous by thread: Does my Windows service need table permissions?
- Next by thread: Select (2+3+8+5+8+3+98+6+2) as Test1, (Test1+4) as Test2
- Index(es):
Relevant Pages
|
