Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    448

    Unanswered: how to use db2look to see the grants

    db2 ver7 on liunux

    Trying to get only the grant statement given by grantor SYSIBM to
    <user1> on <user2>.<table_name.
    The USER enviroment set to instance owner

    I am using this command

    db2look -d <db_name> -z <user1> -x

    but the grants are not showing , I am seeing the grants from the
    syscat.tabauth.

    regards,

  2. #2
    Join Date
    Jun 2003
    Location
    Canada
    Posts
    35

    try -xd

    From the doc:
    -xd
    |
    If this option is specified, the db2look utility will generate all authorization | DDL including authorization DDL for objects whose authorizations were granted | by SYSIBM at object creation time. |

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I would try it without the -z (schema) parameter. The schema name is not necessarily the same as the userid.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Mar 2004
    Posts
    448
    The xd option is introduced in version 8 , what about ver 7.

    regards,

    Mujeeb

Posting Permissions

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