MVSFORUMS.com

monaco · Beginner Joined: 20 May 2004 Posts: 77 Topics: 31

Hi all,

is there a way to know the cobol programs which are selecting, updating, deleting, etc a concret table?

Probably in catalog tables (at the bind time) we can find this information. But i dont know how to do it.

Kind regards.

vini · Posted: Wed Jun 02, 2004 12:21 pm Post subject:

The simplest way is to Search in ISPF Option 3.14 . Use the Table Name as your Search String and your Source Library/PDS as the one to be searched.

kolusu · Posted: Wed Jun 02, 2004 12:22 pm Post subject:

monaco,

Check my posting in this topic

http://www.mvsforums.com/helpboards/viewtopic.php?t=2218&highlight=sysibm

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

monaco · Beginner Joined: 20 May 2004 Posts: 77 Topics: 31

Thanks.
We use to do that.

But, is there a more technical way (through catalog o something like that).

Kind regards.

kolusu · Posted: Wed Jun 02, 2004 12:50 pm Post subject:

Monaco,

Did you read my earlier response?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

monaco · Beginner Joined: 20 May 2004 Posts: 77 Topics: 31

Sorry Kolusu,

while i was writing the before answer you sent you reply.

Thanks a lot.
I'm following the way you told me.

i'll let you know if i find something.

Thanks a lot.

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

Monaco,
Try this...

SELECT DISTINCT(GRANTEE),SELECTAUTH,INSERTAUTH,UPDATEAUTH,DELETEAUTH
FROM SYSIBM.SYSTABAUTH
WHERE TCREATOR = 'xxxxxxxx'
AND TTNAME = 'xxxxxxxxxx'
AND GRANTEETYPE = 'P'
ORDER BY GRANTEE,DELETEAUTH DESC,INSERTAUTH DESC,
SELECTAUTH DESC ,UPDATEAUTH DESC
WITH UR

monaco · Beginner Joined: 20 May 2004 Posts: 77 Topics: 31

Thanks SureshKumar.
It is very usefully.

Thanks to everyone for your help.

monaco · Beginner Joined: 20 May 2004 Posts: 77 Topics: 31

Hi again,

is there a way to get the programs which are pointing a single column?

If a know the column name, can i get which programs points there?

I've been trying with the table SYSIBM.SYSCOLAUTH, but in this table you can see the programs which points there but with update privilige. I'd like to know also select, insert and delete privileges.

Thank a lot.