Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004

    Unanswered: DB2 odbc connection read only

    Hello everybody,

    how can I configure a odbc connection to read only access. On the windows xp machine the db2 adminstration is installed.

    Is a keyword existing for the configuration?

    Thanks toette

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    no not possible
    just have this user granted select authority on needed tables and this will give read authority
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    This is not done at the connection level; grant the user in question only SELECT privileges and revoke INSERT, UPDATE, and DELETE privileges. This is assuming that the user does not have implicit authorities such as DBADM or SYSADM, which override individual object grants.
    "It does not work" is not a valid problem statement.

Posting Permissions

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