Schema browser load non oracle maintained users

Toad for Oracle Idea Pond
1

I would like to see any option added to the schema browser list of users to load. When you open the schema browser, on the left hand side, the top drop down shows the current logged on schema. If you click this drop down, and right click in it, you see the options shown in the screen shot below.

image
image.png820×178 11.2 KB

Since Oracle 12.1, there is a new column on the dba/all_users view named oracle_maintained. If the value for this is Y, it is a built in schema. I would like to have an option to show only the non-built in accounts (select username from dba_users where oracle_maintained = 'N'), since these are the ones that contain my application objects.

2

Not a bad idea. Seems like it would have to be in addition to the others, though, because it's only a 12c and newer column, and this option is not remembered per connection, it's global. You don't want to have to mess with it every time you change connections.

So, I'm thinking...keep the 4 choices in your screen shot, with a checkbox item for "hide oracle maintained" that ANDs into the where clause (if checked)

3

Definitely have it as an additional option to the existing ones.

4

Done for next beta. And I made it less wordy in there.

image
image.jpg874×157 50.3 KB

1 Like
5

Sweet, thanks, I'll be looking forward to that.