Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Unanswered: Access db2 with other users than db2inst1

    Hi there,

    installed db2 on Ubuntu 8.10 today using the standard users (e.g. db2inst1). Everything went fine and I could create a database in the control center (db2cc). Now I want to use the database with other users on the same host (!) as well.

    I do have a java tool which accesses the database. It works fine with user db2inst1 but not with another standard user of the same host.

    Do I need a special configuration to allow other users as well to access the host? I couldn't find it in the documentation.

    Regards,

    Ali

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Did you grant access to that user? See the GRANT statement in the SQL Reference Vol 2.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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