Security: Why don’t roles work in PL/SQL definer’s rights procedures?
Because roles are dynamically enabled and disabled, but PL/SQL is statically compiled.
You may also like
Two Easy Ways to Get SQL_ID in Your Current Session
September 2, 2024
How To Find the SQL_ID of a SQL Statement
July 18, 2024
How To Identify the Execution Plan of a SQL Statement
April 10, 2024