Results 1 to 4 of 4

Thread: creating user

  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: creating user

    how do we create user ?
    is there any way to create them withought being existing as OS ( window/unix) user on the database instance box where database server exists
    like some clients not on the server wants to connect?
    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    DB2 doesn't authenticate users by itself; it refers to the host operating system. As a result, a user must be known to the operating system in order to be authenticated.

  3. #3
    Join Date
    Nov 2003
    Posts
    121

    so it needs to have an os account?

    It nees os account on the box where instance for database is created or from the client machine where it connects from to the database ?

  4. #4
    Join Date
    Jul 2004
    Posts
    25
    It depends on DBM Configuration:
    db2 => get dbm cfg

    .................................................. ...........................................
    .................................................. ...........................................
    Database manager authentication (AUTHENTICATION) = SERVER
    .................................................. ...........................................
    .................................................. ...........................................

    If it's so, user account must be on server side, but we can set AUTHENTICATION to CLIENT:
    db2 => update dbm cfg using authentication CLIENT
    db2 => db2stop force
    db2 => db2start

    And now authetnication will take place at the client machine, and that's why we need to have user account on the client machine

Posting Permissions

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