app roles and ADO connections
From: Diederik (diederikvanpeer@hotmail.com)
Date: 11/08/02
- Next message: J.L.: "Recover historic databases"
- Previous message: Steve Kass: "Re: Read-only Reports User"
- Next in thread: Mary Chipman: "Re: app roles and ADO connections"
- Reply: Mary Chipman: "Re: app roles and ADO connections"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Diederik" <diederikvanpeer@hotmail.com> Date: Fri, 8 Nov 2002 04:13:24 -0800
Hello all,
I'm having problems with the combination of SQL Server
application roles and ADO connections. Although I use a
single ADO connection in my VB application (on which the
sp_setapprole stored procedure is executed), I'm
getting 'EXECUTE permission denied on object...' messages.
On www.sqlteam.com I read the following comment by a user
named Jeffrey:
<quote>
You should note that the use of AppRoles with ADO is
problematic since the approles is strictly a SQL Server
concoction that ADO is apparently not aware of or
programmed to.
In some cases ADO will create additional connections
behind the scenes (especially when connections
are 'busied') and since it doesnt know about approles they
are not propogated automatically to the cloned
connections. As a result, the new conenctions cannot
access the database through the approle and would rely on
whatever other access permisions the user had.
<end quote>
Is there a workaround to prevent ADO from creating these
additional connections? I tried the "OLE DB Services = -2"
option, without success.
Thanks for any help,
Diederik
- Next message: J.L.: "Recover historic databases"
- Previous message: Steve Kass: "Re: Read-only Reports User"
- Next in thread: Mary Chipman: "Re: app roles and ADO connections"
- Reply: Mary Chipman: "Re: app roles and ADO connections"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
