MVSFORUMS.com

[yadav2005]

Hi,

Is there any way to know for what all tables in any TEST / PRD environment my userid has SELECT access to ? I am trying the below query:

[dbzTHEdinosauer]

maybe look for 'PUBLIC'?
_________________
Dick Brenholtz
American living in Varel, Germany

[kolusu]

yadav2005,

The Grantee does NOT always contain individual user id's . It sometimes contains the group name(such as dept you work ). So your table authorities will be listed under that group name.

The best way to find out that info is , get a table name for sure you have access to and try the following query.

[papadi]

[yadav2005]

Thanks Kolusu , your explanation is very clear.

[CZerfas]

If your shop uses the "standard exit" IBM provides for populating the so called SECONDARY USERIDs (DSN3AUTH), you should look, to which RACF groups your userid is connected (under ISPF, type "TSO LU" in the command line).

Then perform your query against SYSTABAUTH with all the group-ids that are listed with the "list user" command, plus of course PUBLIC.

regards
Christian

[computer]

Hi All,

I executed the following query,
SELECT *
FROM SYSIBM.SYSTABAUTH
WHERE STNAME = 'Your table name for which you have select access'

And, I found in the GRANTEE column all the program names were listed which had accesses to this table .

So, well in this case how to get the list.

Thanks in Advance,
Computer

[kolusu]

computer,

Read this post once again

http://www.mvsforums.com/helpboards/viewtopic.php?p=56254#56254

Kolusu

[computer]

I tried executing the command to get the group id name as suggested - 'TSO LU', but ended up with the following error message....

RACF PRODUCT DISABLED: COMMAND ENDED.
***

Thanks in Advance,
Computer