view procedures on other schema
Posted by
Roshan on
Mar 22, 2017; 6:28am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/view-procedures-on-other-schema-tp2402.html
Hi Erman,
I have created a user GAIA_RO on a database. After connecting to sqldeveloper/toad, I want to view the procedures/tables (readonly) of another schema(OPS$IMCC_5X). I have granted DBA to GAIA_RO but I cannot view the objects.
As shown below, on clicking on procedures, I cannot see the procedures of user OPS$IMCC_5X
test.pngThanks,
Roshan