Security: Why don’t roles work in PL/SQL definer’s rights procedures?
- Posted by eliadminaccount
- Date April 26, 2022
Because roles are dynamically enabled and disabled, but PL/SQL is statically compiled.
Previous post
Security: Is Transparent Database Encryption better or worse then file system encryption?
You may also like
3 Processes That Make Data Guard Work
Have you ever wondered what is happening behind the scene in a Data Guard environment? How and who is sending the logs from the primary to standby? What process is applying the changes on the standby side? How is it …
How to Create an Oracle Standby Database in 5 Steps
Setting up Oracle Data Guard for a database might be daunting for many DBAs. The process involves creating a standby database from the primary database and it seems complicated and convoluted, but is it really? When we come across something …
The built in code editor in APEX is missing a very useful thing: the ability to automatically format the code. If you are using a tool like VSCode, Toad or SQL Developer to write your SQL or PL/SQL code, everything …