Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Tag Archives: RCAC

RCAC: Usage Considerations Part 3

Published June 3rd, 2013 - by

In the previous two blogs (http://www.triton.co.uk/confessions-of-a-db2-geek/article/65/DB2-10.1-RCAC:-Hints-&-Tips-Part-1  and http://www.triton.co.uk/confessions-of-a-db2-geek/article/66/RCAC:-Usage-Considerations-Part-2  ) we were discussing the Column Mask and Row Permissions as two separate entities, with potentially different impacts to your database. I’m now going to try and demonstrate some of the issues that can occur when you have the two features enabled on the same table. I’m Continue Reading

RCAC: Usage Considerations Part 2

Published April 3rd, 2013 - by

In the previous blog (http://www.triton.co.uk/confessions-of-a-db2-geek/article/65/DB2-10.1-RCAC:-Hints-&-Tips-Part-1 ) we were discussing the Column Mask part of the RCAC feature. To recap, there are 2 parts to RCAC • Column masks : which over-write or obscure returned values with specified alternatives • Row permissions : which only return the rows of data that you are permitted to see Continue Reading

DB2 10.1 RCAC: Hints & Tips Part 1

Published February 28th, 2013 - by

  Row and Column Access Control (RCAC) in DB2 10.1 for LUW is a neat and simple means of shielding your data from users who don’t need to see it. It’s really two things melded together:   • Row permissions : which only return the rows of data that you are permitted to see • Continue Reading