var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Privileges in DB2
Is there a way to tell which user id has certain privileges in DB2?
I have queried both the SYSDBAUTH and SYSTABAUTH searching to see
if there is a way to see a certain user id.
All I see is DBADM. I want to see the user id's associated with DBADM.
Thanks, MLVTW :
ps. I am working on the mainframe using V7.3 of DB2.
Last edited by mlvtw; 08-31-04 at 19:06.
You do the select from SYSTABAUTH and SYSDBAUTH where GRANTEE = 'userid'. Then you'll see any specific authority granted to that ID.
I forgot - check SYSUSERAUTH too.