If EXECUTE Permission is revoke on DevTest Databases will it Affect the Application?

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)

Issue/Introduction

If EXECUTE Permission is revoke on DevTest Databases will it Affect the Application?

Environment

Release:
Component: ITKOTF

Resolution

In Oracle, EXECUTE privilege, enables user to execute stored procedures, functions and java scripts with-in the database.

We do not have procedures/functions in databases used by registry and ED. So removing EXECUTE permissions will not impact any functionality.