Oracle Magazine, July/August 2017
Database Developer PL SQL ORACLE MAGAZINE JULY AUGUST 2017 76 ERROR at line 1 ORA 00942 table or view does not exist Prior to Oracle Database 12c to get this to work you had to do one of the following Grant SELECT on this table to SCOTT but that would give SCOTT access to confidential information Create a view on top of EMPLOYEES that does not include the confidential information and then grant SELECT on that view to SCOTT With Oracle Database 12c and higher I can instead create a role that has the SELECT privilege on the EMPLOYEES table and then assign the role to just that single procedure Assuming that HR has the CREATE ROLE privilege here are the steps CREATE ROLE view_ employees_ role GRANT SELECT ON employees TO view_ employees_ role GRANT view_ employees_ role TO PROCEDURE show_ employees BEGIN
You must have JavaScript enabled to view digital editions.
