Home » SQL & PL/SQL » Client Tools » Can't see tables from toad
Can't see tables from toad [message #237619] Tue, 15 May 2007 04:18 Go to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Dear all,

I have created a newuser call user2 and grant privileges to
"create session","select" and "create public synonym" to owner user admin (user1) for any table .I tried to connect with user2 to toad program and click
"Schema Browser Window " on tab "table" .I can't see any table !

What 's step am i missing? Please suggest .

Thanks for advance !

Chara
Re: Can't see tables from toad [message #237622 is a reply to message #237619] Tue, 15 May 2007 04:24 Go to previous messageGo to next message
jai_subi
Messages: 7
Registered: May 2007
Location: Chennai
Junior Member
Hi Chara,

Click the schema in schema browser window, the respective objects will be populated.From the tabbed pane, select "Tables" option.The tables in the schema user1 will be populated in the tabbed pane.

Rgds,
Subha Duraikkannu.
Re: Can't see tables from toad [message #237625 is a reply to message #237619] Tue, 15 May 2007 04:36 Go to previous messageGo to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Hi Subha Duraikkannu,

Thank you for your replied.I tried to see but not found. I 'm using toad version 8.0 Did you mean this version ?

Rgds,
Chara
Re: Can't see tables from toad [message #237660 is a reply to message #237619] Tue, 15 May 2007 07:27 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,


YOu can access user1 tables.
as far as you want to see you never create some table from user1 ...you grant select privs or create synonym you should check SYNONYM OPTION in TOAD.


regards
Taj

Previous Topic: iSQL*PLUS
Next Topic: Toad problem
Goto Forum:
  


Current Time: Sun Dec 11 07:49:57 CST 2016

Total time taken to generate the page: 0.15645 seconds