Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    9

    Unanswered: no privilege to operate on sysibm.sysdummy1

    Hi,

    I am using OJB (o/r mapping tool) and db2 7.2. When I try to store an object I get the exception, that a select operation on table sysibm.sysdummy1 could not be processed because the user has no privilege to execute this command... ? What happens here? Have I to grant sysibm tables for users?

    any idea?

    Dirk

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

    Re: no privilege to operate on sysibm.sysdummy1

    GRANT SELECT ON SYSIBM.SYSDUMMY1 TO <username>

    Cheers
    Sathyaram

    Originally posted by db2_learner99
    Hi,

    I am using OJB (o/r mapping tool) and db2 7.2. When I try to store an object I get the exception, that a select operation on table sysibm.sysdummy1 could not be processed because the user has no privilege to execute this command... ? What happens here? Have I to grant sysibm tables for users?

    any idea?

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

  3. #3
    Join Date
    Nov 2003
    Posts
    9

    Re: no privilege to operate on sysibm.sysdummy1

    Originally posted by sathyaram_s
    GRANT SELECT ON SYSIBM.SYSDUMMY1 TO <username>

    Cheers
    Sathyaram

    So I obviously have to grant users for sysibm tables... Please could you short explain to me, what sysdummy1 is for? Thank you.

  4. #4
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    ABOUT SYSIBM.SYSDUMMY1

    Hi

    The sysibm.sysdummy table is equivalent to the dual in oracle.

    However the official DB2 Explanation for the same is below.

    Contains one row. This view is available for applications that require compatibility with DB2 Universal Database for OS/390.

    Table 41. SYSCAT.DUMMY1 Catalog View
    Column Name Data Type Nullable Description
    IBMREQD CHAR(1) Y

    Cheers

    Nitin.
    HTH

    Nitin

    Ask the experienced rather than the learned

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: ABOUT SYSIBM.SYSDUMMY1

    As Nitin said, if you want to select a dummy row, say , you want the current timestamp , you use the sysibm.sysdummy1 table

    select current timestamp from sysibm.sysdummy1 will retrurn a single row ...

    The other option is to use VALUES

    VALUES(CURRENT TIMESTAMP)

    Not sure if this is supported on OS/390 DB2 ...

    About the privileges, it depends on the privileges you grant to other objects ... If all tables are granted access to a group, say GRP1, then it makes sense to grant access to this view also to GRP1

    HTH

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

Posting Permissions

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