Results 1 to 4 of 4

Thread: Roles and ODBC

  1. #1
    Join Date
    Nov 2003
    Posts
    8

    Unanswered: Roles and ODBC

    Hello,

    Is there a config parameter, that disables the "set role ...".

    When a user is in a role, the first thing he has to do is to run "set role rolename".

    When this user connect with ODBC to run his queries, this is impossible.

    Regards,

  2. #2
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: Roles and ODBC

    When you let the users connect to Informix via ODBC, you should consider to build the role assignment into your client app.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

  3. #3
    Join Date
    Nov 2003
    Posts
    8
    And if this is a third party tool, like Access.

  4. #4
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447
    .... then you work either with fixed username / password combinations, or you may consider to make a form in MS Access to let the user specify his/her role, which you may translate into a SET ROLE statement.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •