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

    Unanswered: Privileges for Server creation

    Hi,

    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
    Location
    USA
    Posts
    5,737
    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
  •