sql permissions and adp

From: Lynn (anonymous_at_discussions.microsoft.com)
Date: 10/28/03 

Date: Tue, 28 Oct 2003 08:00:06 -0800

I have am using an .adp (2000) to connect to sql 2000.
The problem is that some of my forms do not work when I
test the application using the standard user permissions.
I have sa rights and everything works for me but I can't
get the users to work. I have created roles and users and
given permissions to all the sp, views, and tables and
they still can't open most of the forms. Basically the
only way to get them to work is to give the group sa
rights which obviously we do not want to do.

Thanks!

Relevant Pages

  • Re: Understanding SQL and Microsoft GP
    ... You shouldn't even need DBO rights. ... DBA and having him profile a session where the Excel reports are being run. ... SQL Server MVP ... access to SQL server because I have no database knowledge. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL/User Account
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... "RAJ" wrote in message ... SQL Server Service Manager indicated SQL ...
    (microsoft.public.sqlserver.security)
  • Re: Vista hosting XPe tools/db
    ... SQL Express isn't installing that should be there. ... This posting is provided "AS IS" with no warranties, and confers no rights. ... Yes - I'm running the script on a machine that has SQL 2005 Express SP1 ... Although I managed to install the SP1 database with no errors, ...
    (microsoft.public.windowsxp.embedded)
  • Re: Cant create DB on remote server
    ... rights in SQL as indicated in the WSS Admin Guide. ... > Also assume that you are installing in Web Farm Mode vs Single Server ...
    (microsoft.public.sharepoint.windowsservices)
  • REPOST:SQL Login with no Fixed Server Role and DB Role can stop SQL Agent Service?
    ... I had checked all the user rights, and everything seems to be proper...but ... running SQL 2000 Enterprise Edition on ... Windows 2000 Server. ... SQL Server on his Enterprise Manager using this SQL Login. ...
    (microsoft.public.sqlserver.security)