I've got an Oracle 126.96.36.199 database and I need to create a read only user that can view any table, view, package, etc. I've created the user but I can't figure out how to give it read only access to packages, procedures and functions. The only option seems to be granting execute any procedure. I don't want the user to be able to execute the procedure just view the code. Any suggestions?
January 11, 2006 9:04 AM
January 12, 2006 8:19 AM