Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2010
    Posts
    1

    Unanswered: db2 9.1.9 metadata query

    Hi

    Our DB2 version is 9.1.9 on AIX. I would like to

    1) Find the Database authorities owned by PUBLIC. We can get this information from command centre but I would like to know the tables which store this information.

    2) Find fenced stored routines for a user.

    Thanks and Regards
    Lsanthan

  2. #2
    Join Date
    Oct 2007
    Posts
    246
    syscat.dbauth

    regds
    Paul

  3. #3
    Join Date
    Oct 2007
    Posts
    246
    chk this link
    Preventing Public Access to the DB2 Database — DatabaseJournal.com
    for more info on public

    regds
    Paul

Posting Permissions

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