I can reproduce the ORA-942 in Toad (as well in SQL*Plus) but only when the role is not default. The following query shows “NO” for the DEFAULT_ROLE field. When I make the role default then “select * from schema.table” returns data as expected. I don’t know of anything specific in Toad that would change that other than on the “Oracle|Roles and Editions” page in options. Do you have anything set in there?
From: zoom5 [mailto:firstname.lastname@example.org]
Sent: Wednesday, December 09, 2015 3:17 PM
Subject: [Toad for Oracle - Discussion Forum] Can’t See Tables in TOAD editor
Can’t See Tables in TOAD editor
Thread created by zoom5
Below is my issue. Hopefully someone can help.
create role roleA;
grant select on SchemaA.TableA to roleA;
grant roleA to SchemaB;
In SQLPlus client window or on the server. logging in as SchemaB:
Select * from SchemaA.TableA -->> returns all data
In TOAD window. logging in as SchemaB (same as #4):
Select * from SchemaA.TableA -->> returns ORA-00942: Table or view does not exist
Help? The fact that I can’t do it in TOAD, but can in SQLPlus client window AND on the server tells me that there is something/setting in TOAD that’s preventing me from seeing the data. Anyone has any idea what that is?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.