GRANT select ON gv_$reserved_words TO PUBLIC;REVOKE execute ON dbms_lob FROM public;REVOKE execute ON utl_file FROM public;REVOKE execute ON utl_inaddr FROM public;REVOKE execute ON utl_smtp FROM public;-- you will want to add many more to this list

/*
To use this form of the ALTER DATABASE statement, the database must be in ARCHIVELOG mode. This requirement prevents you from accidentally losing the datafile, since taking the datafile offline while in NOARCHIVELOG mode is likely to result in losing the file.
*/