Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2015
    Posts
    2

    Unanswered: what are the important tables in db2?

    hello

    Im studying db2, about security (alone).
    so I have a lot of questions.. T.T

    I want to know what are the important tables in db2 ?
    such as db2 configure table, system table..

    and then I want block the table from user(general user) who doesn't have permission.


    thanks for reading my question.
    Last edited by yeseulJ; 08-10-15 at 22:10.

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hello,

    start reading from here: DB2 security model overview
    Regards,
    Mark.

  3. #3
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    you can start off with any table/view that has a name of %AUTH% and work from there
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  4. #4
    Join Date
    Aug 2015
    Posts
    2

    thanks for your reply :)

    I try more and more haha

Posting Permissions

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