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

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

Postby 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
pitou
 
Posts: 1
Joined: Thu 22 Dec 2016 08:55

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

Postby 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
alexa
Devart Team
 
Posts: 1856
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle