Re: Application Roles and Visual Basic 6
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 06/25/02
- Next message: Raks: "Re: Alert for SQL Server Shutdown and Startup events"
- Previous message: John Criswell: "Application Roles and Visual Basic 6"
- In reply to: John Criswell: "Application Roles and Visual Basic 6"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Mon, 24 Jun 2002 16:39:24 -0600
Try the following article in SQL Mag by Andy Baron, Mary
Chipman:
Mastering Application Roles
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=20534
-Sue
On 24 Jun 2002 15:18:26 -0700, jcriswel@jdcconsulting.net
(John Criswell) wrote:
>I'm interested in how to code access to a SQL Server 2000 database
>with the use of application roles. Can anyone refer me to a book or
>some other documentation on how to implement this? Basically, this
>would be a two-tier client/server application using VB6 on the
>front-end, ADO and OLE DB for connectivity, and SQL Server 2000 on the
>back-end. I want to start up the application and have it authenticate
>the user. After authentication, the VB app allows the user access to
>data in the database through an application role. The usual strategy
>being pursued here is that the user does not have a database user
>account that will allow him/her into the database using Enterprise
>Manager or Query Analyzer. He/she can only access the data in the
>database through the application.
>
>Any suggestions will be greatly appreciated.
>
>John Criswell
>jcriswel@jdcconsulting.net
- Next message: Raks: "Re: Alert for SQL Server Shutdown and Startup events"
- Previous message: John Criswell: "Application Roles and Visual Basic 6"
- In reply to: John Criswell: "Application Roles and Visual Basic 6"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
