Oracle Magazine, July/August 2017
Database Developer PL SQL 2 Grant the role to the procedure This can be done as SYSDBA It can also be done from the HR schema if the role is granted to HR with the admin option Heres the grant as SYSDBA ORACLE MAGAZINE JULY AUGUST 2017 73 GRANT create_ table_ role TO PROCEDURE hr drop_ table To grant it from HR first execute this as SYSDBA GRANT create_ table_ role TO hr WITH ADMIN OPTION ALTER USER hr DEFAULT ROLE ALL EXCEPT create_ table_ role Then execute the grant from HR GRANT create_ table_ role TO PROCEDURE create_ table And now I can execute the procedure and successfully create the table BEGIN create_ table my_ table END
You must have JavaScript enabled to view digital editions.