Results 1 to 4 of 4
  1. #1
    Join Date
    May 2016
    Posts
    3

    Unanswered: LBAC column of DB2 9.7 LUW using in WHERE clause which does not having read permissio

    Dear All,

    We would like to know more about the LBAC column and row of DB2 9.7 LUW in WHERE clause which column does not have read access rights for the user.

    See below example :

    Table1:
    Column1 - Protected and No read access for user1
    Column2 - Normal
    Column3 - Normal

    Table2:
    Column4 - Protected and No read access for user1
    Column5 - Normal
    Column6 - Normal

    SQL executed by USER 1:

    SELECT Column2, Column3, Column5, Column6 from Table1, Table2 WHERE Table2.Cloumn4 = Table1.Column1;

    Question : What will be the result after executing above query by USER1

    Thanks & Regards,
    Rathvel.

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    You should get SQL20264N

    BTW: Is this so hard just to try it?
    Regards,
    Mark.

  3. #3
    Join Date
    May 2016
    Posts
    3

    Not able to test by own. Hence, requesting you all inputs.

    Mark.b,

    Thank you very much for your information.

    We are expolring the options and not having DB2 version to test by own. Hence, I raised this query to all forum members to check if possible before providing the details.

    Thanks & Regards,
    Rathvel.
    Last edited by rathvel; 05-12-16 at 04:04.

  4. #4
    Join Date
    May 2016
    Posts
    3

    LBAC column of DB2 9.7 LUW using in WHERE clause which does not having read permissio

    Quote Originally Posted by rathvel View Post
    Mark.b,

    Thank you very much for your information.

    We are expolring the options and not having DB2 version to test by own. Hence, I raised this query to all forum members to check if possible before providing the details.

    Thanks & Regards,
    Rathvel.
    Dear All,

    Could you pls provide your inputs to proceed further on this?

    Many thanks in Advance.

    Thanks & Regards,
    Rathvel.

Posting Permissions

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