Add explicit grants for public packages

barsema · web-flow · commit 3b003561e5f0 · 2022-08-31T11:21:34.000+02:00
The privileges on the referenced packages are often revoked from PUBLIC as database hardening. Not relying on these grants being available makes the install script more robust.
diff --git a/source/create_utplsql_owner.sql b/source/create_utplsql_owner.sql
@@ -41,6 +41,11 @@ end;
 /
 
 grant execute on dbms_crypto to &ut3_owner_schema;
+grant execute on dbms_lob    to &ut3_owner_schema;
+grant execute on dbms_xmlgen to &ut3_owner_schema;
+grant execute on dbms_sql    to &ut3_owner_schema;
+grant execute on dbms_random to &ut3_owner_schema;
+
 
 grant alter session to &ut3_owner_schema;
 

Original file line number	Diff line number	Diff line change
`@@ -41,6 +41,11 @@ end;`
`41`	`41`	`/`
`42`	`42`
`43`	`43`	`grant execute on dbms_crypto to &ut3_owner_schema;`
	`44`	`+grant execute on dbms_lob to &ut3_owner_schema;`
	`45`	`+grant execute on dbms_xmlgen to &ut3_owner_schema;`
	`46`	`+grant execute on dbms_sql to &ut3_owner_schema;`
	`47`	`+grant execute on dbms_random to &ut3_owner_schema;`
	`48`	`+`
`44`	`49`
`45`	`50`	`grant alter session to &ut3_owner_schema;`
`46`	`51`