mailsaurabh.tripathi
New User
Joined: 22 May 2008 Posts: 56 Location: hyderabad
|
|
|
|
Hi
I need the list of the programs using 'abcd' table.
So I used the following options:
1. I ran the following query
SELECT GRANTEE, UPDATEAUTH,INSERTAUTH,SELECTAUTH
FROM SYSIBM.SYSTABAUTH
WHERE
GRANTEETYPE = 'P' AND
TTNAME = 'ABCD'
AND TCREATOR = ‘XYZ’
ORDER BY GRANTEE
This gave me 84 rows.
2. I ran following two querys,
a.SELECT BNAME,DNAME
FROM SYSIBM.SYSPLANDEP
WHERE BNAME = 'abcd'
AND BTYPE = 'T'
AND BCREATOR = 'XYZ'
WITH UR;
b.SELECT BNAME,DNAME
FROM SYSIBM.SYSPACKDEP
WHERE BNAME = 'KMP_VOLUME_CNTLT'
AND BTYPE = 'T'
AND BQUALIFIER= 'XYZ'
WITH UR;
These two querys give 71 rows togther.
Can you please suggest for the difference. |
|