Skip to Content
0
Former Member
Jul 13, 2015 at 02:22 PM

Reverse Engineering Permission Table

26 Views

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!