Results 1 to 3 of 3

Thread: Db2 Users

  1. #1
    Join Date
    Feb 2007
    Posts
    31

    Unanswered: Db2 Users

    Hi,
    Is there any way to know how many users are present in Datatabase.?(eg. Any catalog tables,Like in oracle dba_users..?)

    Version: 8.1.1.2.4
    Fix pack level : 3
    Regards
    Mohan

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You can query the connections using the LIST APPLICATIONS command or by accessing the respective snapshot table functions.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by d_mohan81
    Hi,
    Is there any way to know how many users are present in Datatabase.?(eg. Any catalog tables,Like in oracle dba_users..?)

    Version: 8.1.1.2.4
    Fix pack level : 3
    In DB2, user ids are controlled at the OS level. However, the OS user id must be granted access to an object within DB2.

    You could look at the syscat.dbauth and syscat.tableauth (and other views that end in AUTH) to see which users have been granted access to a DB2 resource. The complete list of catalog views in the SQL Reference Vol 1 Appendix D.

    For sysadmin access that may have been granted, look in the dbm config.
    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
  •