RE: 11.6 SB Read Only Relationship to Startup-Check for Access to DBA Views

Hi Chuck,

  There was a change in 11.6 to make the grid read only if you are browsing tables in other schemas, and you don't have the update any table priv, and you don't have update privs on the selected table.   There was a bug in the way we checked for the update priv on the given table, but it is fixed now in beta.

  This is the first I've heard of unchecking 'check for access to dba views' as a solution to this problem, and also the first I've heard of it not detecting 'update any table'.   Is that priv granted directly or through a role?  If through a role, does a direct grant fix it?

  The reason for the change is that some people would try to update the table, learn they don't have privs by way of an Oracle error, but since the grid did a 'select for update', a lock would be obtained on the row, and it would stay there, causing problems for others.

  As a workaround, do a CTRL+E (E for 'Edit') on the table in the SB LHS and it will send an editable query on the table to the Editor.

-John



From: [email protected] [mailto:[email protected]] On Behalf Of chuckoneal99
Sent: Wednesday, February 27, 2013 8:09 PM
To: [email protected]
Subject: [toad] 11.6 SB Read Only Relationship to Startup-Check for Access to DBA Views



I have an account with select any dictionary/table along with insert/update/delete any table and alter any trigger(data correction account without complete DBA privs in a QA environment). In 11.6 the SB data grids are read only and I can't change it. I saw older posts directing uncheck "Startup-Check for Access to DBA Views". It did unmask the SB grid read only checkbox, but does other crazy stuff like hides all triggers. The same account in 11.5 did not enforce SB read-only and I'm able to leave Startup-Check for Access to DBA Views enabled. Also related, I started the 11.6 with elevated access on just 1 table and it did not respect the privs. The SB read-only is restricting the real access unless I'm missing something.