Permission Denied to object

From: Jim (Jim_at_discussions.microsoft.com)
Date: 02/25/05 

Date: Fri, 25 Feb 2005 07:07:07 -0800

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

Relevant Pages

  • Re: SBS R2 Confused Computers/Users ??
    ... MyBusiness container to SQL Server security section. ... Please let me know whether these Windows user accounts can login to ... Are you get any error message when you add the user to SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Login problem
    ... This is probably all due to my limited understanding of SQL Server security, ... My app requires a user to login to the database. ... SQL Server is set up to use mixed authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Checking if a table exists, so that it may be dropped before recreating it
    ... This is the method SQL Server uses when it generates scripts. ... "Dr Tarheel" wrote in message ... I'd like to skip the DROP TABLE command and go straight to the ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL 2005 Full Text Multi-Column Ranking
    ... > I looked all over the internet and can't find a straight answer, ... In SQL Server 2005 you can provide a column list instead of a single column ... Prev by Date: ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Printing my Stored Procedures
    ... It is pretty straight forward. ... Vyas, MVP (SQL Server) ...
    (microsoft.public.sqlserver.server)