Auditing an Oracle database for security issues is very important. PeteFinnigan.com provides all of the information and tools that you will need Click here for details of PeteFinnigan.com Limited's detailed Oracle database security audit service Click here for details of PeteFinnigan.com Limited's Oracle Security Training Courses
There are 48 visitors online    
Cookie Policy:We only use essential cookies on small sections of this website. For details see here.

Pete Finnigan's Oracle security weblog


Home » Archives » March 2005 » Jonathan Lewis on Row Level Security

[Previous entry: "Google desktop search"] [Next entry: "Sean Hulls weblog site is back up"]

Jonathan Lewis on Row Level Security

March 10th, 2005 by Pete


I was searching on google for something the other day and by accident I came across a paper by Jonathan Lewis about row level security. I had not seen this paper before so i saved it in an open window to look at later. I have just had time to read it now. The paper is titled "Row Level Security Part 1" and you might expect from Jonathan is very well written. I am not sure when it was written but judging by the mention of 9.2.0.3 in the first paragraph it was a while ago. It is still quite relevant though.

The paper is the first in a series. I will get the others and have a look in a day or so. I am a bit busy at present. This paper starts off with some history and some examples of how it used to be done with a table, a trigger and a view. This is an excellent example that talks about performance issues and the appearance of sys_context() and its displacement of userenv().

Jonathan then goes on to detail contexts and gives examples showing how the previous example can be improved. He talks about and explains contexts in detail. This is an excellent article. I will track down the other parts and get back to you on those soon as well.

March 2005
SMTWTFS
  12345
6789101112
13141516171819
20212223242526
2728293031  

This is the weblog for Pete Finnigan. Pete works in the area of Oracle security and he specialises in auditing Oracle databases for security issues. This weblog is aimed squarely at those interested in the security of their Oracle databases.

Weblog Home
Weblog Archives


Home
Oracle Security Tools page
Oracle security papers
Oracle Security alerts

Web Development
SQL Server Security

RSS 1.0 FEED
RSS 2.0 FEED
Atom 0.3 FEED
Powered by gm-rss 2.0.0


Valid XHTML 1.0!