Results 1 to 3 of 3
  1. #1
    Join Date
    May 2005
    Posts
    25

    Unanswered: Finding Users and Groups

    Can you please say me how to find user's and groups created in DB2 database? I search through lot of resurces but vain.

    we have in oracle dba_users/all_users.....we have roles there but DB2 I have no idea since I am novice.

    your response is much useful for me.

    Thanks,
    Shahnaz.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    DB2 does not have users and groups defined within it. It uses external means (like the OS) to perform the security. All that DB2 stores is the authorizations of the users and groups.

    Andy

  3. #3
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    If you will query the system catalog views for those authorizations (like syscat.schemaauth, syscat.tabauth, etc) you will get a list with all the users/groups that have privileges in your database. And you may suppose that this is the users and groups list.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

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