Reverse Engineering Permission Table

[Former Member]

Hello Folks,

I have a problem with reverse engineering in the permission of a Table using a DB2 database... I added the item SqlPermQuery in the DBMS file, in my tests when I do the reverse engineering, I have two results:

If I put:

{GRANTEE, PERMISSION}

select 'USER1' GRANTEE, 'SELECT' PERMISSION

from sysibm.sysdummy1

The permissions don't appear...

If I put:

{USER, PERMISSION}

select 'USER1' GRANTEE, 'SELECT' PERMISSION

from sysibm.sysdummy1

The permission appear, but the property "User" comes with "None" and the property "Grant" comes with "SELECT" (the correct permission).

I think that the property in the DBMS (GRANTEE/USER) is wrong, but I didn't find one that brings me the correct result.

Help will be appreciated.

Thank you!

[former_member182952]

Hi Bruno,

What version of PD are you using?

What DB2 DBMS file are you using?

Thanks,

Adam

[Former Member]

Hello Adam,

Thank you the return. I'm using PD version 16.5.4.0.

I created the DBMS related to the file of the AS/400.

Thank you!