Re: Application Roles and ADP files
From: Mary Chipman (mchip@nomail.please)
Date: 03/18/03
- Next message: Bob: "password and Id"
- Previous message: Claudete: "Upgrade SQL 7.0 -> SQL 2000"
- In reply to: CSDunn: "Application Roles and ADP files"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Mary Chipman <mchip@nomail.please> Date: Tue, 18 Mar 2003 15:53:17 -0500
Approles and ADPs don't mix all that well. If you want to do extra
work, you can get it going, more or less. For more info, see
http://support.microsoft.com/default.aspx?scid=KB;en-us;308312
-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
On Mon, 17 Mar 2003 14:15:18 -0800, "CSDunn" <cdunn@valverde.edu>
wrote:
>Hello,
>I have a SQL Server 2000 database with at least four MS Access 2000 ADP
>applications connecting to the database. I find myself having to alter
>current roles for the database by making permissions more liberal in order
>to accommodate users that use multiple applications. This, of course,
>increases my security risk to different database objects.
>
>I have read just a little on Application Roles in SQL Server 2000, and
>wanted to know where I might find some resources for working this type of
>security scheme into an MS Access 2000 Project.
>
>If you have any suggestions, information, or resources, please let me know.
>Thanks for your help!
>
>CSDunn
>
- Next message: Bob: "password and Id"
- Previous message: Claudete: "Upgrade SQL 7.0 -> SQL 2000"
- In reply to: CSDunn: "Application Roles and ADP files"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
