Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2015
    Location
    Bucharest
    Posts
    9

    Answered: Create new users for database

    Hello!
    I`m new into DB2`s world and for now i put newbies questions.
    I have a database and I want to create new users who can connect to my database. They must have only permissions to connect to db ,select,insert and delete data from database.
    For now, I know that I can connect to my database with my windows account only.
    Can someone help me and guide my to a solution ?

    Regards!

  2. Best Answer
    Posted by tafster

    "further to what Guy has said, you need to review the DB2 security model to understand privileges and authorisations. Userids do not exist in DB2 (unlike Oracle) - DB2 only uses O/S userids.

    http://www-01.ibm.com/support/knowle.../c0021804.html"


  3. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    users are not maintained in db2 only grants
    Can someone help me and guide my to a solution --> this is the direction to go (please read and try to understand before execute...)

    http://www-01.ibm.com/support/knowle...-7-158&lang=en
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #3
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    further to what Guy has said, you need to review the DB2 security model to understand privileges and authorisations. Userids do not exist in DB2 (unlike Oracle) - DB2 only uses O/S userids.

    http://www-01.ibm.com/support/knowle.../c0021804.html
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you cant get them together again, there must be a reason. By all means, do not use hammer. IBM maintenance manual, 1975 "

Posting Permissions

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