Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013
    Posts
    31

    Unanswered: How to grant domain user access to DB2 9.5 (Windows) DB

    Hi. Our DB2 LUW 9.5 database runs on Windows Server 2003, but I'm unsure how to grant a domain user Read access to certain tables so she can connect in via Access. I've added the user's domain account to the DB2Users group on the server (local group, not domain), then I added the domain username to the database under User and Group Objects > DB Users with Connect to Database permissions plus permissions to a set of tables.

    Then I created an ODBC connection it's prompting for a username and password instead of offering pass through authentication for the domain. Even entering my domain info it still says it can't connect.

    Can someone point me to a tutorial or maybe write-up a quick one showing how to grant a domain user access to a DB2 database? Or is it not possible to add a domain user? If not how do I setup a local user?

    Thanks.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by samalex01 View Post
    I've added the user's domain account to the DB2Users group on the server (local group, not domain), then I added the domain username to the database under User and Group Objects > DB Users with Connect to Database permissions plus permissions to a set of tables.
    That should be sufficient.

    Quote Originally Posted by samalex01 View Post
    instead of offering pass through authentication for the domain.
    There's no such thing as "pass-through authentication" in DB2, unless you write your own authentication plugin or use Kerberos. You'd need to provide the user ID and password each time you connect to the database remotely.
    ---
    "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
  •