Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    1

    Unanswered: cannot retreive data

    Hello everyone,
    i installed the db2 client database.i created a username password iam trying to access the data of employee table of sample database..iam not able to get the data the error is

    For more information about DB2 privileges search the DB2 Information
    Center for "privileges" and "granting privileges" .

    sqlcode: -551

    sqlstate: 42501, 5UA0K

    My query wasELECT * FROM "SYSTEM"."DEPARTMENT";

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Seems that your user does not have enough privileges. Take a look of GRANT statement.
    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

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