IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to find out ? Who all have access to a particular table
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India
PostPosted: Thu Aug 28, 2008 10:08 pm
 Reply with quote
Hello,

I want to know all the people who have access to a particular table in the database in the db2 subsystem.

Example,

Code:
SUBSYSTEM : DB2D
DATABASE   : ProdPara
TABLE          : Address

I want to know who all can access Address table of database ProdPara in DB2D subsystem.
Back to top
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore
PostPosted: Fri Aug 29, 2008 5:15 pm
 Reply with quote
You can try the following query.

SELECT GRANTEE FROM SYSIBM.SYSTABAUTH WHERE TTNAME = ’Address’ AND GRANTEETYPE <> ’P’
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts How to access web services/website? Mainframe Interview Questions 4
No new posts Pulling a fixed number of records fro... DB2 2
No new posts To find whether record count are true... DFSORT/ICETOOL 6
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us