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

    Unanswered: DB2 User creation


    Please someone help me to create a new user in DB2 server and mapping that user to a database instance and giving privilages. I am using Linux OS and DB210.2.

  2. #2
    Join Date
    May 2005
    Create OS user and grant him privileges in the DB. There is no specific command to create a user in DB2. Once you grant access to objects for the OS user, he should be able to access the db

    Here is the link to the document on some of the restrictions

    IBM DB2 10.5 Information Center for Linux, UNIX, and Windows

  3. #3
    Join Date
    Feb 2014
    example :

    useradd -g db2iadm1 test

    db2 connect to db1

    db2 grant dbadm on database to user hari

    Here db2 users are the users at OS level.

Posting Permissions

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