Installed Toad for Oracle 11.6.1 Commercial on a new Windows 7 machine with Oracle 11g full client.
Connects through Toad to a schema with a user that is not the schema owner but has been granted nearly full privileges. Not able to edit the data in the data grid in Editor Window.
In the schema browser's data grid, the "Read Only" check-box is checked and disabled. Connecting as the schema owner, the data can be edited. Also tried replacing the Toad.lic file with the FullToad.lic file.
Also, under Toad Options -> Data Grids -> Data -> Behavior, the "Use read-only queries" is not checked.
Connecting using the schema with the non-owning user through ODBC from Microsoft Access, the data can be edited. The problem is persistent and occurs in various schemas. Doing the same thing on Windows XP machine with Oracle 10g instant client and Toad 11.0, the data can be edited just fine whether logged in as the schema owner or the other user.
If a table is in another schema, the SB in 11.6 attempts to check the UPDATE privilege on a table. If the update privilege is not found, and the user does not have the UPDATE ANY TABLE sys privilege, the grid is read only.
The problem is that we used a data dictionary view (TABLE_PRIVILEGES) that apparently Oracle doesn't always keep up to date.
WORKAROUND:
In 11.6, log-in as the owner of the tables, or go to the Editor, type 'EDIT <tablename>' and make the edits there.
From the Schema Browser, do a CTRL+E ('E' for 'Edit'); this will open an Editor with a query that will allow editing of the table.
Running an UPDATE statement for the table will also work.
