Is there an additional option entry for the Editor window under the option listed in View | Toad options | Oracle | General | Default Schema | 'Used in'? So, this option would also work in Editor, making the user context be changed automatically in the Editor and ability to write table names directly (without the schema name as prefix) in the SQL statement?
When using 3 different schemata in the database, like A and B and C.
"A" has a table: DATA1. B and C has rights (select, insert, update, delete) to A.DATA1 table.
1. Login with B or C user.
2. Change manually the default schema to A in Editor (Current Schema item on toolbar).
3. Query all data from DATA1 (don't need to identify the schema in the sql query) -> select rowid, column from DATA1.
It is not possible to update records in the result grid because of the message: "ORA-00942 Table or view does not exists".
When changing the default schema in View | Options | Oracle | General | Default schema for the connection, it only effects the Schema Browser and not the Editor window. The Editor option needs to be changed manually through drop down on the toolbar.
WORKAROUND:
None
STATUS:
Enhancement request ER 34408 has been submitted to Development for consideration in a future release of Toad for Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center