Re: view procedures on other schema

Posted by ErmanArslansOracleBlog on Mar 22, 2017; 9:58am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/view-procedures-on-other-schema-tp2402p2405.html

The grants that are delivered by the DBA role, differs according to your db version.
The method that is used by tools to display the procedure code, may differ according to your tool and its version, as well.
This is a tool related question, but I will try to answer.
1)Try granting "SELECT ANY CATALOG" to the user.
If not solved ->
2)Try granting "execute grant" on the procedures you want to the user.
If not solved ->
3)Try granting "debug grant" on the procedures you want to the user.
If not solved ->
Send me the Toad version, RDBMS version and the output of the following SQL:

SELECT PRIVILEGE
  FROM sys.dba_sys_privs
 WHERE grantee = <YOUR_USER>
UNION
SELECT PRIVILEGE
  FROM dba_role_privs rp JOIN role_sys_privs rsp ON (rp.granted_role = rsp.role)
 WHERE rp.grantee = <YOUR_USER>
 ORDER BY 1;