Application Role

From: Norbert Meiss (NorbertMeiss_at_discussions.microsoft.com)
Date: 12/26/04

  • Next message: Erland Sommarskog: "Re: Application Role" 
    Date: Sun, 26 Dec 2004 06:05:02 -0800

    Hi,

    I have an Access 2003 project which uses a "dummy" login for the standard
    connection without any rights on objects. After establishing the ADO
    connection via VBA code I enable the application role which is then used to
    do all database access

    cn.Execute "EXEC sp_setapprole 'App_Role', '" & strPW & "'"

    This works fine unless I assign a rowsource via a code line like this

    ...Form.RecordSource = "Exec GET_" & Str_SubFormName & " " & strWhere

    This works only when I assign the dummy login the right to execute the
    stored procedure. It is not enough to assign this right to the Application
    role. But this means that the dummy role has access to this table via the
    stored procedure which I wanted to avoid. What do I miss, or is this by
    design? Any other solutions for this scenario?

    TIA,
    Norbert Meiss

  • Next message: Erland Sommarskog: "Re: Application Role"

    Relevant Pages

    • Re: Insert Row into IBM DB2 (AS400)
      ... You don't actually copy the data to the dummy table/database, ... parsed, you can change your connection back to your ODBC connection, ... Once you copy the data into the dummy SQL database how exactly do you ... the same structure as your db2 table. ...
      (microsoft.public.sqlserver.dts)
    • Re: Adding a computer to a domain
      ... TEH network ID and change buttions are both grayed out. ... administrator or local administrator if attempting to change this. ... Maybe I am also confused by the term 'dummy' login and how it is restricted. ...
      (microsoft.public.win2000.dns)
    • Re: How can you tell if a socket is closed?
      ... I have resorted to a dummy read so that an exception is thrown when the ... // dummy read on raw input to force error if connection broke ... Dave Rathnow wrote: ...
      (comp.lang.java.programmer)
    • Re: OleDBConnection problem if database sesison is killed or database is restarted
      ... > Is there is any method to reset connection pool? ... I append some dummy parameters ... I tried by putting extra sapaces in connection string, ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: fries, chips cause cancer
      ... > Now I'm feeling a bit like a dummy. ... > the LA Times in Bugmenot, and the response was "login failed". ... registration boxes. ...
      (rec.bicycles.racing)