Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2004
    Posts
    36

    Angry Unanswered: SQL0551- EXECUTE on Nullid... URGENT

    SQL0551N "PARAPS01" does not have the privilege to perform operation
    "EXECUTE" on object "NULLID.SQLC2D03". SQLSTATE=42501


    i am getting this error.....

    can we give execute on that object.
    or do i have to bind it again...

  2. #2
    Join Date
    Oct 2002
    Posts
    4

    Smile

    Quote Originally Posted by prithvi_raj
    SQL0551N "PARAPS01" does not have the privilege to perform operation
    "EXECUTE" on object "NULLID.SQLC2D03". SQLSTATE=42501


    i am getting this error.....

    can we give execute on that object.
    or do i have to bind it again...
    Try this :

    GRANT EXECUTE ON PACKAGE NULLID.SQLC2D03 TO USER PARAPS01

    Is you have not enough authority contact your DB2 admin, i would do that for you.

  3. #3
    Join Date
    Apr 2004
    Posts
    36
    My Question was Wrong.

    Thats not waht i want.

    How come we manually give rights on the NULLID packages?
    They are internal to UDB. UDB shouldn't throw thses kind of errors?

    But how come i got this error? Is some thing got screwd internally?

    >>Is you have not enough authority contact your DB2 admin, i would do that for you.<<


    yeah go ahead and do that...i appreciate )

  4. #4
    Join Date
    Jan 2005
    Posts
    191
    The packages might have come with DB2, but IBM believe (and so do I) that they should be subject to the same security checks as anything else. However, IBM normally a) names their packages SYSxxxxx or DB2xxxxx and b) grants execute on them to PUBLIC as part of the installation.

    Are you sure it came from IBM?

    James Campbell

  5. #5
    Join Date
    Mar 2005
    Posts
    73

    Sql0551n

    I am also getting similar kind of erro.

    SQL0551N "tuskman" does not have the privilege to perform operation "EXECUTE"
    on object "NULLID.SQLxxxE06". SQLSTATE=42501

    I though the packaage SQL* are generated by UDB and UDB will grant EXECUTE permissions to public by default . Isn't it correct.

    WHat is the solution to the above issue ?

    OS :Aix , UDB 8.1 FP5.

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by prithvi_raj
    SQL0551N "PARAPS01" does not have the privilege to perform operation
    "EXECUTE" on object "NULLID.SQLC2D03". SQLSTATE=42501


    i am getting this error.....

    can we give execute on that object.
    or do i have to bind it again...
    Please indicate your DB2 version, fixpack, and OS, and describe exactly what you doing when this error occured.
    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
    Aug 2001
    Location
    UK
    Posts
    4,650
    When you bind the package list containing nullid packages, you will have to grant execute to public
    Eg:

    bind @db2ubind.lst blocking all grant public

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

  8. #8
    Join Date
    Mar 2005
    Posts
    73
    Marcus,


    OS : AIX , UDB V8.1 FP7.
    Our People soft admin guys is tyring to select count(*) from the table .
    He couldn't able to do it. Not only him , the other application ids alos
    not able to do the same things.

    We have recently restoed a backup into this server. That is the only difference i can see. And recently upgrared to FP7 by our colleague.

    tanks

Posting Permissions

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