Hi all,

how to view the user groups in DB2 (e.g. PUBLIC, SYSADM, DBADM)
and figure out which user is in which group?

Thanks
ME

Depends on your platform ...

Have a read through
http://www.dbforums.com/t854783.html

which should give you general hints on posting

Cheers
Sathyaram

Hi all,

In DB2 version 5 on Win2000,
how to view the user groups in DB2 (e.g. PUBLIC, SYSADM, DBADM)
and figure out which user is in which group?

Thanks
ME

DB2 uses the operating system users and group information for its authentication and authorizatiion ...


PUBLIC - Anyone who has access to the system

SYSADM,SYSCTRL, SYSMAINT - the values of SYSADM_GROUP, SYSCTRL_GRP, SYSMAINT_GROUP dbm cfg parms ... Check the group name and go to the OS list to know the group names

DBADM - DBADMAUTH column in SYSCAT.DBAUTH . The GRANTEETYPE column specifies if it is a group or user ..

Generally all authorizations on the database objects are held in SYSCAT views which end with AUTH .. For V5,


DBAUTH
INDEXAUTH
PACKAGEAUTH
SCHEMAAUTH
TABAUTH

How DB2 works with NT security documnetation can be found in http://www-306.ibm.com/cgi-bin/db2ww...9.htm#HDRNTSEC

HTH

Sathyaram