RE: Permission Denied to object
From: Jim (Jim_at_discussions.microsoft.com)
Date: 02/25/05
- Previous message: Jim: "Permission Denied to object"
- In reply to: Jim: "Permission Denied to object"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 25 Feb 2005 07:37:03 -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 brought up SQL Server and migrated our Access 2000 back end DB to
> it. The SQL Server security seemed pretty straight forward to me...I set up
> the users and the roles and assigned the roles rights to my tables. The
> problem is that my users get a Permission Denied error when ever the Access
> 2000 front end tries to access any SQL Server table unless I add them to the
> System Administrator server role. I've gone over everything and I can't seem
> to figure this out. The only thing I can find that seems strange is that on
> that database, my login name is associated with the "dbo" name. I think that
> makes me the owner of the db and I'm wondering if that is what is causing my
> issue. I'd greatly appreciate any insight on how to get this issue taken
> care of.
> Thanks in advance!
> Jim
- Previous message: Jim: "Permission Denied to object"
- In reply to: Jim: "Permission Denied to object"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
