MVSFORUMS.com

Anand_R · Intermediate Joined: 24 Dec 2002 Posts: 189 Topics: 60

Hi,

Is there any sql command that lists the id's that have privileges to access the particular plan..

Thanks
Anand

Bithead · Posted: Wed Jul 09, 2003 9:49 am Post subject:

SELECT * FROM SYSIBM.SYSPLANAUTH WHERE NAME = 'MYPLAN';

Anand_R · Intermediate Joined: 24 Dec 2002 Posts: 189 Topics: 60

Thanks for your help Bithead...Infact I tried for that command, but I don't even have authorization to access that table.. I do have for other catalog tables.. Is there anyway that I can find out , what are all catalog tables that I do have access by my id..

Thanks

Bithead · Posted: Wed Jul 09, 2003 12:11 pm Post subject:

That is the only way that I know of.