Results 1 to 5 of 5

Thread: ODBC readonly

  1. #1
    Join Date
    Oct 2002
    Location
    Germany
    Posts
    6

    Unanswered: ODBC readonly

    Hello,

    According to security issues I don't want to use ODBC in read/write mode. Is there any posibility out there to configure the Client 2.70 TC3 NT /W2k for read only mode?

    thanks

    wocky

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    There is no flag or env var to be set in order to have a read-only odbc connection.

    You could create an odbc user with only read-only permissions...

    f.ex.

    user odbc.

    1. Make sure the user 'public' doesn't have RESOURCE or DBA or CONNECT permission...
    in dbaccess:
    unload to revoke_permissions.sql DELIMITER ';'
    SELECT "REVOKE ALL ON " || tabname || " FROM public"
    from systables
    where tabname > 99
    and tabtype = 'T'

    2. Execute the revoke_permissions.sql

    3 Set permissions for user 'odbc'

    in dbaccess:
    unload to set_permissions.sql DELIMITER ';'
    SELECT "GRANT SELECT ON " || tabname || " TO odbc"
    from systables
    where tabname > 99
    and tabtype = 'T'

    4. execute the set_permissions.sql

    Let every odbc user connect to the database with that user.
    rws

  3. #3
    Join Date
    Oct 2002
    Location
    Germany
    Posts
    6
    thank you,

    but more than 80 databases and many different user - permissions makes it very hard to realize your sugestion.

    wocky

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Correct, but it works...
    rws

  5. #5
    Join Date
    Oct 2002
    Location
    Germany
    Posts
    6
    th@ks

Posting Permissions

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