well, talk about timely. i'm tasked to implement a security feature,
and would rather do so in the database than the application code. the
application is generally Oracle, but sometimes DB2. Oracle has what
it calls package DBMS_RLS, which implements application ignorant
row level security.
scanning this group yielded "you can't do that; use views". then i
dug out DB2Mag qtr 1 2004, and there is MLS for v8/390. from this
article, it sounds like Oracle's RLS.
when i try to download the referenced pdf, it fails. hmmm.
so, has anyone who has implemented RLS on Oracle and knows more about
MLS on DB2 say whether, i) they are functionally equivalent and
ii) really works on DB2.
thanks,
robert
and would rather do so in the database than the application code. the
application is generally Oracle, but sometimes DB2. Oracle has what
it calls package DBMS_RLS, which implements application ignorant
row level security.
scanning this group yielded "you can't do that; use views". then i
dug out DB2Mag qtr 1 2004, and there is MLS for v8/390. from this
article, it sounds like Oracle's RLS.
when i try to download the referenced pdf, it fails. hmmm.
so, has anyone who has implemented RLS on Oracle and knows more about
MLS on DB2 say whether, i) they are functionally equivalent and
ii) really works on DB2.
thanks,
robert