Minimum Oracle Permissions needed to view Functions and Procedures
説明
What permissions are needed in Oracle to view your own procedures and functions? What permissions are needed to view other schemas permissions and functions?
対策
To view your own procedures and functions, you need to grant the following:
RESOLUTION #1:
1. SELECT CATALOG_ROLE privilege with default option 2. ALSO: Make sure that you have the following enabled in Toad. Go to View | Options | Startup >> Check for access to DBA views� Click Ok. Restart Toad and see if you can view functions/procedure.
RESOLUTION #2:
1. Grant Select on DBA_OBJECTS and DBA_SOURCE 2. ALSO: Make sure that you have the following enabled in Toad. Go to View | Options | Startup >> Check for access to DBA views� Click Ok. Restart Toad and see if you can view functions/procedure.
RESOLUTION #3:
1. Grant EXECUTE ANY PROCEDURE or grant EXECUTE
To view other peoples procedures you will need the following:
RESOLUTION #1:
1. SELECT CATALOG_ROLE privilege with default option 2. ALSO: Make sure that you have the following enabled in Toad. Go to View | Options | Startup >> Check for access to DBA views� Click Ok. Restart Toad and see if you can view functions/procedure.
