Oracle Magazine, July/August 2017
Database Developer PL SQL But when I try to create a table using the procedure I see an error ORACLE MAGAZINE JULY AUGUST 2017 72 CONNECT HR BEGIN create_ table my_ table END ERROR at line 1 ORA 01031 insufficient privileges Prior to Oracle Database 12c the only way HR could use this procedure was to grant the CREATE TABLE privilege to the schema itself But that meant that any program unit defined in HR could then create a table which the chief security officer would find unacceptable With Oracle Database 12c however I can take a much more fine grained approach by granting privileges to the procedure itself and not its owning schema Heres how 1 Create a role from a schema with the authority to do so and grant it the CREATE TABLE privilege CREATE ROLE create_ table_ role GRANT CREATE TABLE TO create_ table_ role
You must have JavaScript enabled to view digital editions.