Well,well, well!
It's quigleyd! Hehe. The query may help! Hehe.

SELECT *
FROM SYSCAT.TABAUTH AS TABAUTH
WHERE TABAUTH.TABNAME LIKE 'EMP_%'
AND GRANTEE = 'ED.EDWARDS'
ORDER BY TABNAME, GRANTEE;

Partyyyyyyyyy! Hehe.

Have a great Day!






Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: quigleyd
[mailto:db2udbdba-ezmlmshield-x95004019.[Email address protected]
Sent: Tuesday, October 23, 2007 8:42 AM
To: LazyDBA Discussion
Subject: See what users have access within DB2



I need to know if there's a query or an easy way to see all the users
who have
been granted any type of access in DB2. I know i can look at the groups
at the
unix level to see the majority of them. This is for DB2 v9.1



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.


---------------------------------------------------------------------
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

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