Security Problem - Permission denied
From: Jim (Jim_at_discussions.microsoft.com)
Date: 02/25/05
- Next message: Pranay Pandya: "Re: Auditing SP Execute."
- Previous message: Geoff N. Hiten: "Re: All users can start and stop SQL Server?"
- Next in thread: Jim: "RE: Security Problem - Permission denied"
- Reply: Jim: "RE: Security Problem - Permission denied"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 25 Feb 2005 06:49:06 -0800
We recently installed SQL Server 2000 and have upsized our Access back end
database to SQL Server. I have added all of our users to SQL Servers logins
and assigned them to the proper roles. We are still using that same Access
2000 front end. My problem is that anyone who tries to run the system gets a
permission denied error on any table they attempt to access unless I add them
to the "System Administratiors" server role. Clearly, I do not want to have
to add everyone to that role. SQL Server security seemed pretty straight
forward to me and I can't figure out what I missed. I would greatly
appreciate any help that anyone has to offer.
Thanks in advance,
Jim
- Next message: Pranay Pandya: "Re: Auditing SP Execute."
- Previous message: Geoff N. Hiten: "Re: All users can start and stop SQL Server?"
- Next in thread: Jim: "RE: Security Problem - Permission denied"
- Reply: Jim: "RE: Security Problem - Permission denied"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
