RE: Security Problem - Permission denied
From: Jim (Jim_at_discussions.microsoft.com)
Date: 02/25/05
- Next message: Riki: "Re: All users can start and stop SQL Server?"
- Previous message: Jim: "RE: Permission Denied to object"
- In reply to: Jim: "Security Problem - Permission denied"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 25 Feb 2005 07:39:04 -0800
Nevermind, I found the answer to my problem in another post. Don't assign
the db_denydatareader or db_denydatawriter role to the user. That cleared up
my problem.
"Jim" wrote:
> 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: Riki: "Re: All users can start and stop SQL Server?"
- Previous message: Jim: "RE: Permission Denied to object"
- In reply to: Jim: "Security Problem - Permission denied"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
