query to find access



IBM's flagship relational database management system

query to find access

Postby ranga_subham » Thu May 13, 2010 9:34 am

Hi,

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

Please help.

Thanks.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: query to find access

Postby dick scherrer » Thu May 13, 2010 9:46 am

Hello,

SYSIBM.SYSTABAUTH table. Look here:
http://publibz.boulder.ibm.com/cgi-bin/ ... sqj10/F.70
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post