Results 1 to 3 of 3

Thread: db2 admin issue

  1. #1
    Join Date
    May 2012
    Posts
    2

    Unanswered: db2 admin issue

    There are two user accounts in my system running Windows 7 Professional OS.

    1) Chandra
    2) db2admin

    After I created a local DB2 Server, I am able to insert,update, delete db2 tables only when I log in from db2admin.

    When I login through Chandra user Id, I am able to execute only select queries. But this is the user id where I am logged in most of the time.

    Can you guys please help me in making Chandra also get the privileges that is present for db2admin userid and execute all the queries (insert,update, delete) from this userid.

    Thanks.

  2. #2
    Join Date
    May 2012
    Posts
    2

    db2 admin issue

    The actual error I am getting is as follows,


    com.ibm.db.DataException: A database manager error occurred. : [IBM][CLI Driver][DB2/NT64] SQL0551N "CHANDRA" does not have the required authorization or privilege to perform operation "SELECT" on object "DB2ADMIN.CONTEQUIV". SQLSTATE=42501

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

Posting Permissions

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