Page 1 of 1

query to find access

PostPosted: Thu May 13, 2010 9:34 am
by ranga_subham
Hi,

How to find out whether a user have access against a table? Query should be made against which SYSIBM table?

Please help.

Thanks.

Re: query to find access

PostPosted: Thu May 13, 2010 9:46 am
by dick scherrer
Hello,

SYSIBM.SYSTABAUTH table. Look here:
http://publibz.boulder.ibm.com/cgi-bin/ ... sqj10/F.70