View Procedure Definition or Table of another user from dbForge for Oracle

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
pitou
Posts: 1
Joined: Thu 22 Dec 2016 08:55

View Procedure Definition or Table of another user from dbForge for Oracle

Post by pitou » Thu 22 Dec 2016 09:02

Hello,

I have two users A and B in a oracle database. I create a table tbl1 and a procedure proc1 on user A.
I have grant select permission on table tbl1 and view procedure definition proc1 to user B.
Then login DB with user B via bForge for Oracle. But I can not see table tabl1 and proc1.
Could you help me on this to see table and procedure ?

Regards,
Pitou

alexa

Re: View Procedure Definition or Table of another user from dbForge for Oracle

Post by alexa » Thu 22 Dec 2016 15:31

You could try selecting the 'Show All Objects' option on the 'General' page of the Database Connection Properties dialog box that can be opened by right-clicking the connection in Database Explorer and selecting 'Modify Connection...' from the popup menu.

If this still doesn't help, please provide us the permissions of the user B.

You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom

Post Reply