Toad World® Forums

Some Tables Read-Only


#1

Lately I’ve noticed that some tables in our database are Read-Only in the Schema Browser. Most of the tables are not so it isn’t the connection that is causing it. I’m running 12.0 but I get this same thing if I log into TOAD 11.6 on this PC. However, if I log into TOAD 11.5.2 on my other PC, the tables are not Read-Only. I can’t figure out how the tables are getting set to Read-Only.


#2

On connection screen scroll all way to left and see if you made (checked) any of your connections as read only …

From: Julie Milazzo [mailto:bounce-jperont@toadworld.com]

Sent: Thursday, July 25, 2013 11:44 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Some Tables Read-Only

Some Tables Read-Only

Thread created by Julie Milazzo

Lately I’ve noticed that some tables in our database are Read-Only in the Schema Browser. Most of the tables are not so it isn’t the connection that is causing it. I’m running 12.0 but I get
this same thing if I log into TOAD 11.6 on this PC. However, if I log into TOAD 11.5.2 on my other PC, the tables are not Read-Only. I can’t figure out how the tables are getting set to Read-Only.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#3

Scroll right I meant – scroll the whole grid ….

From: Bert Scalzo

Sent: Thursday, July 25, 2013 11:45 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Some Tables Read-Only

On connection screen scroll all way to left and see if you made (checked) any of your connections as read only …

From: Julie Milazzo [mailto:bounce-jperont@toadworld.com]

Sent: Thursday, July 25, 2013 11:44 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Some Tables Read-Only

Some Tables Read-Only

Thread created by Julie Milazzo

Lately I’ve noticed that some tables in our database are Read-Only in the Schema Browser. Most of the tables are not so it isn’t the connection that is causing it. I’m running 12.0 but I get
this same thing if I log into TOAD 11.6 on this PC. However, if I log into TOAD 11.5.2 on my other PC, the tables are not Read-Only. I can’t figure out how the tables are getting set to Read-Only.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#4

11.6 had a check to make the SB-tables-data grid read only if you don’t have update privs on the table. The way it checked wasn’t perfect though, and it was
improved for Toad 12.

Using Toad 12, when you see a read only grid in the SB – are you sure you have privs to make changes to that table?

A quick way to check (and workaround, if it is a bug) would be to do a CTRL+E (think E for Edit or Editor) on the table name in the SB LHS. That will open
an Editor and put a query to edit that table in the editor.

Then see if you can make an edit in the grid and post it (by clicking on another row).

From: Julie Milazzo [mailto:bounce-jperont@toadworld.com]

Sent: Thursday, July 25, 2013 11:44 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Some Tables Read-Only

Some Tables Read-Only

Thread created by Julie Milazzo

Lately I’ve noticed that some tables in our database are Read-Only in the Schema Browser. Most of the tables are not so it isn’t the connection that is causing it. I’m running 12.0 but I get
this same thing if I log into TOAD 11.6 on this PC. However, if I log into TOAD 11.5.2 on my other PC, the tables are not Read-Only. I can’t figure out how the tables are getting set to Read-Only.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#5

I checked the connection manager & nothing is checked as Read Only. Not all of the tables are Read Only, just a few of them.

I checked the editor & yes, I can make a change. The reason I noticed the table is Read-Only is that I tried to make a change & couldn’t. I update this table fairly often using Toad.


#6

I think then try John’s suggestion about control-e then ….

From: Julie Milazzo [mailto:bounce-jperont@toadworld.com]

Sent: Thursday, July 25, 2013 11:57 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Some Tables Read-Only

RE: Some Tables Read-Only

Reply by Julie Milazzo

I checked the connection manager & nothing is checked as Read Only. Not all of the tables are Read Only, just a few of them.

I checked the editor & yes, I can make a change. The reason I noticed the table is Read-Only is that I tried to make a change & couldn’t. I update this table fairly often using Toad.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#7

Try this:

Start Toad and make your connection. From the main menu, go to database -> Spool SQL -> Spool to Screen. This will begin a capture of every SQL statement
that Toad executes.

Open the schema browser and go to one of the tables that it’s marking as read only, and go to the data tab.

Then send me the Spool sql output. You can send it to
john.dorlon@quest.com

Thanks.

-John

From: Julie Milazzo [mailto:bounce-jperont@toadworld.com]

Sent: Thursday, July 25, 2013 11:57 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Some Tables Read-Only

RE: Some Tables Read-Only

Reply by Julie Milazzo

I checked the connection manager & nothing is checked as Read Only. Not all of the tables are Read Only, just a few of them.

I checked the editor & yes, I can make a change. The reason I noticed the table is Read-Only is that I tried to make a change & couldn’t. I update this table fairly often using Toad.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#8

I did the control-e & was able to edit :-).

John, I’ll get that to you shortly