| Can't see tables from toad [message #237619] |
Tue, 15 May 2007 04:18  |
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  |
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 #237660 is a reply to message #237619] |
Tue, 15 May 2007 07:27 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
