Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2014

    Unanswered: Privileges for Server creation


    I am very new to DB2 DBA things. I started learning now. I came across a scenario where , to create a DB2 user (userID) on my server & that userID should have privileges to create Wrappers & servers to interact with other databases also.

    I have created a USER on my windows machine, with out doing any thing, i can find the same user on my DB2 server. Now i need to add previleges to this newly created user.r
    What are all the privileges required for a user to create a Wrappers & servers on the db2 server?

    can I give directly these previliges using GRANT command from my ROOT user?

    Please let me know.

  2. #2
    Join Date
    May 2003
    Check out the Reference Manual for CREATE WRAPPER. It will tell you what privileges are needed to use that command.

    If you are on Linux/UNIX, the DB2 instance owner id can usually grant what is needed. Even though root is needed to create a user in the OS (and to create a DB2 instance), root has no privileges inside DB2 (unless granted by instance owner, which is not a good idea).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Tags for this Thread

Posting Permissions

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