Results 1 to 2 of 2

Thread: DB user list

  1. #1
    Join Date
    Dec 2002
    Posts
    104

    Unanswered: DB user list

    Hi All,

    I am new to DB2.
    Can anyone of you please tell me how can i get the list of DB users thru DB2 database.

    thanx a ton in advance,
    Pooja

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    In DB2, user id's and passwords are controlled by the operating system. Users logged into the operating system can have specific authorities for various objects or groups of objects. You can also grant authority at the operating system group level, in addition to the user id level.

    The DB2 authorizations are stored in various DB2 System Catalog views such as:

    SYSCAT.DBAUTH
    SYSCAT.TABAUTH
    SYSCAT.ROUTINEAUTH
    SYSCAT.SCHEMAAUTH
    etc.

    You can see the defintion of these catalog views in the SQL Reference Vol 1, Appendix D.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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