Re: sp_setapprole with third party program using ODBC

From: A. Tolga KILINĒ (kilinc@tis.havelsan.com.tr)
Date: 08/27/02 

From: "A. Tolga KILINĒ" <kilinc@tis.havelsan.com.tr>
Date: Tue, 27 Aug 2002 16:11:52 +0300

As I understand there is no place to add such a command to MS ODBC settings
(I mean the ODBC GUI) "execute sp_setapprole". I don't think that the 3rd
party supplies such an option also.
Thanks.
Tolga

"Andrew J. Kelly" <akelly@targitinteractive.com> wrote in message
news:##yvilcTCHA.3588@tkmsftngp08...
> Please post only to the NG's so everyone can share in the answers:
>
> if I check "automatically execute when sql server starts" for
sp_setapprole
>
> procedure, maybe 3rd party tool can login with a valid user account and
then
>
> automatically use the application role? What do you think? Is
sp_setapprole
>
> feature for only custom written applications ? or for programs using
command
>
> prompt?
>
> Thanks
>
> Tolga
>
>
> This is not intended for that purpose. In order to run the sp_setapprole
> the user must first login in some fashion and execute this on that
> connection.
>
> --
> Andrew J. Kelly SQL MVP
> Targitinteractive, Inc.
>
>
>
> "Andrew J. Kelly" <akelly@targitinteractive.com> wrote in message
> news:udqJwScTCHA.1496@tkmsftngp11...
> > I don't know of a way offhand to force a 3rd party app to use this. The
> > application must be setup to call this sp after it logs in initially.
You
> > may want to contact the vendor and see if they have thought of this
> > scenario. Maybe someone else that has used app roles with 3rd party
apps
> > will have some insight.
> >
> > --
> > Andrew J. Kelly SQL MVP
> > Targitinteractive, Inc.
> >
> >
> >
> > "A. Tolga KILINĒ" <kilinc@tis.havelsan.com.tr> wrote in message
> > news:#JV0WOcTCHA.1672@tkmsftngp12...
> > > Hi,
> > > I defined an application role, and I know that I have to run it with
> > > sp_setapprole. ok, but how can I say to my third party program using
> ODBC
> > to
> > > see and execute this stored procedure? From desktop/administration
> > > tools/ODBC settings of Windows? What are the next steps?
> > >
> > > Thanks.
> > > Tolga
> > >
> > >
> >
> >
>
>

Relevant Pages