This is something I wrote the other day...
I output it to a text file and imported it into a spreadsheet for easier
viewing and distribution.

select
rtrim(tcreator) concat '.' concat rtrim(ttname) as Table_Name,
case
when substr(granteetype,1,1)='G' then 'Group'
else 'User'
end as Grant_Level,
rtrim(grantee) as ID,
case
when substr(selectauth,1,1)='Y' then 'Select'
else null
end,
case
when substr(insertauth,1,1)='Y' then 'Insert'
else null
end,
case
when substr(updateauth,1,1)='Y' then 'Update'
else null
end,
case
when substr(deleteauth,1,1)='Y' then 'Delete'
else null
end
from
sysibm.systabauth
order by
1,3,2;

Douglas Kostelnik
Senior Database Administrator/Architect

-----Original Message-----
From: Som_Kundu
[mailto:db2udbdba-ezmlmshield-x57419927.[Email address protected]
Sent: Tuesday, February 19, 2008 8:40 AM
To: LazyDBA Discussion
Subject: Query for listing




Hi,



I need a lists to view users name and their permission (select, update
...) on a tables and procedures.. Is there any query available, please
let me know



Thanks & Regards

Som Subhro Kundu
HCU Enterprise Applications
EA - ESO - DBA Services
Satyam Computer Services Limited
Hyderabad
Work : (+91) 40 30636089
Cell : (+91) 9703242200





DISCLAIMER:
This email (including any attachments) is intended for the sole use of
the intended recipient/s and may contain material that is CONFIDENTIAL
AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or
copying or distribution or forwarding of any or all of the contents in
this message is STRICTLY PROHIBITED. If you are not the intended
recipient, please contact the sender by email and delete all copies;
your cooperation in this regard is appreciated.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



------------------------------------------------------------------------
The information transmitted is intended only for the person(s) or entity to which it is addressed
and may contain confidential and or privileged material and should be treated as a confidential
AAA Auto Club South communication. If the reader of this message is not the intended recipient, you
are hereby notified that your access is unauthorized, and any review, dissemination, distribution, or
copying of this message including any attachments is strictly prohibited.
========================================================================


DB2 & UDB email list listserv db2-l LazyDBA home page