I wrote about the Code Based Access Control (CBAC) stuff in Oracle Database 12c a while back.
I’ve recently “completed the set” by looking at the INHERIT PRIVILEGES and BEQUEATH CURRENT_USER stuff for PL/SQL code and views respectively.
- Control Invoker Rights Privileges for PL/SQL Code in Oracle Database 12c Release 1 (12.1) (INHERIT [ANY] PRIVILEGES)
- Control Invoker Rights Privileges in Views in Oracle Database 12c Release 1 (12.1) (BEQUEATH CURRENT_USER)
It’s pretty cool, but I’m not sure how much of it I will see in the wild as it will require developers to do a bit more thinking, rather than doing what they’ve always done… 🙂
Cheers
Tim…
Invoker Rights in Oracle Database 12c : Some more articles | The ORACLE-BASE Blog http://t.co/m6QUFhLn4D
RT @oraclebase: Invoker Rights in Oracle Database 12c : Some more articles | The ORACLE-BASE Blog http://t.co/m6QUFhLn4D
RT @oraclebase: Invoker Rights in Oracle Database 12c : Some more articles | The ORACLE-BASE Blog http://t.co/m6QUFhLn4D
RT @oraclebase: Invoker Rights in Oracle Database 12c : Some more articles | The ORACLE-BASE Blog http://t.co/m6QUFhLn4D
RT @oraclebase: Invoker Rights in Oracle Database 12c : Some more articles | The ORACLE-BASE Blog http://t.co/m6QUFhLn4D
Invoker Rights in Oracle Database 12c : Some more articles | The ORACLE-BASE Blog http://t.co/TCJXD6XEOe … via @oraclebase
Invoker Rights in Oracle Database 12c : Some more articles http://t.co/oE7QBkzEzZ
>…as it will require developers to do a bit more thinking…
I’m *always* thinking. Granted — often what I’m thinking is that I really wish I’d used a little more foresight before writing some code…