Cannot see the Grants on a Function or Procedure when performing a Describe (F4) (4228535)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Cannot see the Grants on a Function or Procedure when performing a Describe (F4)
Description

Performing a Describe (F4) on a table shows all Grants on the script tab. However when performing a Describe on a Function or other PL/SQL object, it only shows a source tab which does not contain any of the Grants on the object. How can this be shown?
Resolution

For a table a Describe shows the script. For a function or procedure, it shows the Source.
The source will display just that: the source code to create the PL/SQL object (function, procedure, package, etc.). Source also gives you a mini navigator for parameters, that's not needed for a DDL script.
To get the script of a PL/SQL object, in the Describe window click the "Create Script" button or Right-click the Source code and select the "Create Script" option (both have the same icon) which will show all the grants and drop commands, etc.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title