Results 1 to 9 of 9
  1. #1
    Join Date
    Jul 2005
    Posts
    25

    Unanswered: Execute grant poblem

    Hi, everybody

    I encountered a very strange behavior of DB2. There are two SELECT statements listed below. The difference is presencing UPPER function in the second statement. When I execute these statements (in the same session without any other statements) the first one works properly but the second one returns an exception

    SQL0551N "USER1" does not have the privilege to perform operation "EXECUTE"
    on object "SCHEMA1.FUNCTION1". SQLSTATE=42501

    The first statement:
    select *
    from table1
    where SCHEMA1.FUNCTION1 ( column1 ) = 1

    The second statement:
    select *
    from table1
    where SCHEMA1.FUNCTION1 ( upper(column1) ) = 1

    table1.column1 and the parameter of SCHEMA1.FUNCTION1 have varchar type.
    Execute permition granted to a group containing USER1.
    DB2 version: 8.1.1.88 + FixPack 9
    Platform: AIX

    Any ideas what causes the difference in behavoir. Please advise.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Raise a PMR

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Dec 2005
    Posts
    39
    maybe some packages could be missing which need to be rebound to the database. If you do db2 ? sql0551 from windows/unix prompt you'll get the error description, one of which is utility programs missing.

  4. #4
    Join Date
    Jul 2005
    Posts
    25
    Quote Originally Posted by sathyaram_s
    Raise a PMR

    Sathyaram
    Sorry, but I don't understand what you have meant to say "Raise a PMR"

  5. #5
    Join Date
    Jul 2005
    Posts
    25
    Quote Originally Posted by murali_sb
    maybe some packages could be missing which need to be rebound to the database. If you do db2 ? sql0551 from windows/unix prompt you'll get the error description, one of which is utility programs missing.
    Thanks for reply!

    I'll check your suggestion...

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by NGambler
    Sorry, but I don't understand what you have meant to say "Raise a PMR"
    A PMR is a problem that you open with IBM support (they assign a PMR number), assuming that you have a support contract.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  7. #7
    Join Date
    Jul 2005
    Posts
    25
    Thanks Marcus
    I see

  8. #8
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Check for the presence of overloaded SCHEMA1.FUNCTION1 and/or UPPER functions; do you have identical problems when column1 is CHAR(1) instead of VARCHAR? Try e.g. SCHEMA1.FUNCTION1 ( upper('a') ) = 1
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  9. #9
    Join Date
    Jul 2005
    Posts
    25
    4 Peter
    thank for reply

    I have identical problems when column1 is CHAR(1) and
    select *
    from sysibm.sysdummy1
    where SCHEMA1.FUNCTION1 ( upper('a') ) = 1
    returns an exception

    SQL0551N "USER1" does not have the privilege to perform operation "EXECUTE"
    on object "SCHEMA1.FUNCTION1". SQLSTATE=42501

Posting Permissions

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