Results 1 to 4 of 4

Thread: DB2 groups

  1. #1
    Join Date
    Mar 2004
    Posts
    33

    Arrow Unanswered: DB2 groups

    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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DB2 groups

    Depends on your platform ...

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

    which should give you general hints on posting

    Cheers
    Sathyaram

    Originally posted by john_wsm
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Mar 2004
    Posts
    33

    RE

    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

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: RE

    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •