Re: sql permissions and adp
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 10/29/03
- Previous message: Kalen Delaney: "Re: Question about dropping owner's permissions..."
- In reply to: Lynn: "sql permissions and adp"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 29 Oct 2003 09:54:11 -0700
Somethings probably missing on the security with whatever
objects the forms use. If you run profiler to monitor what's
being execute and include auditing the object and statement
permissions (under the security audit class), that should
give you enough information to see what's failing where.
-Sue
On Tue, 28 Oct 2003 08:00:06 -0800, "Lynn"
<anonymous@discussions.microsoft.com> wrote:
>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!
- Previous message: Kalen Delaney: "Re: Question about dropping owner's permissions..."
- In reply to: Lynn: "sql permissions and adp"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
