Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2011
    Posts
    54

    Unanswered: Schema/User Permission issue

    I installed DB2 on windows XP with domain user so it created schema with name of “user.name” and stored all sample database object under that user, now when I connect sample database and trying to select any table it gives insufficient permission error even all object are available in same user schema.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    probably because you created the object from within another user
    eg
    connect to db user db2inst1
    create table xx.yy
    in that case grant should be given to xx
    if create tab auth was give to xx
    connect to db user xx
    create table xx.yy
    this user would have all auth
    do some reading in infocenter about this
    Authorization
    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

  3. #3
    Join Date
    Jul 2011
    Posts
    54

    SAMPLE Database object permission

    I did not created any object in SAMPLE database, these all objects are created on DB2 installation under mine window system domain name schema.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    so : grant is needed for this user/public.....

    did you use user.name as schema ??
    check if this character . is allowed.....
    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

Posting Permissions

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