Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007

    Unanswered: How to know Authorized users of the Database

    Can we know who are all the authorized users for a Database by using any query or does DB2 has an builtin routine to know who are all the authorized users and what type of access they have to the database

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    You can query the system catalog views, there are several of them listing authorizations: SYSCAT.DBAUTH, SYSCAT.TABAUTH, etc. The complete list of the system catalog views can be found in the SQL reference manual.

    In addition to that, you may want to include the members of the OS groups listed in the SYSADM_GROUP and other groups with instance-level authorities.
    "It does not work" is not a valid problem statement.

Posting Permissions

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