Re: sp_setapprole with third party program using ODBC

From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 08/27/02 

From: "Andrew J. Kelly" <akelly@targitinteractive.com>
Date: Tue, 27 Aug 2002 08:59:03 -0400

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

  • Re: An absolute Newbie question
    ... I have a question about using "IDLE", and that is whenever I start write my own program in the "Python Shell" it will automatically execute whatever ... Launch IDLE. ...
    (comp.lang.python)
  • An absolute Newbie question
    ... I have a question about using "IDLE", and that is whenever I start write my ... own program in the "Python Shell" it will automatically execute whatever ... So, how to I get it to not execute, so that I can write a program that has ...
    (comp.lang.python)
  • Automatically Execute Excel Macro at 6:00 am
    ... I have an excel macro that I need to execute at 6:00 am Monday morning ... automatically execute the Macro at the desired time. ...
    (microsoft.public.excel.programming)