Toad World® Forums

User Filter


#1

It would be a nicety to have one of the feature options in the User list
of the Schema Browser to only show those users who own objects. I know
that is available in the Export (or Datapump?) wizard, but it would be a
nice addition to the Schema Browser.

I’m just sayin’…

David A. Hicken
UtahToad at gmail dot com
---------- Kiva.org - Make a Small Loan. Make a Big difference.
'Tis always morning somewhere in the world.
–Richard Henry Horne


#2

That feature is in there – under the main menu you will find a user filter
setting/screen and it offers exactly that and several other useful combinations


#3

View > Options > Schema Browser

Setting to configure just this, or even limit to those who own objects not
including synonyms


#4

Arsk and ye have received. J In my 9.7 Toad it’s Options/Schema
Browser/Data/radio button under User/Schema Lists.

Have a great weekend!

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image001.jpeg


#5

All good and well, and I knew about this, but it seems to me that this would be
a filter item instead of a setting. As a DBA I have to maintain users, so
sometimes I want to see all users, and other times only the users that have
objects. Just seems more like a filter than a setting.

I’m just sayin’…

David A. Hicken
UtahToad at gmail dot com
---------- Kiva.org - Make a Small Loan. Make a Big difference.
A mind is like a canvas: The more open your mind, The more colors you can use.
– Ehren Goossens

Jeff Smith wrote:

View > Options > Schema Browser

Setting to configure just this, or even limit to those who own objects not
including synonyms


#6

David, The option that others have mentioned affects the schema name drop-downs
in the SB and other places in Toad. It does not affect the list shown in the
USERS tab. I will add what you have requested to the filter, assuming that I can
figure out a way to squish it into the gui. :slight_smile: In the meantime, as a
workaround, I guess you know that you can edit the query which populates the SB
LHS. Just open the filter dialog, click ‘custom filter’, then OK,
and it should be obvious after that. -John


#7

Thanks, John. Just seemed like a logical filter choice, kind of like the
“Through DB Link” choice on synonyms. – David A. Hicken UtahToad at gmail
dot com ---------- Kiva.org - Make a Small Loan. Make a Big difference. Life
is what happens while you’re busy making other plans. – John Lennon John
Dorlon wrote: David, The option that others have mentioned affects the
schema name drop-downs in the SB and other places in Toad. It does not
affect the list shown in the USERS tab. I will add what you have requested
to the filter, assuming that I can figure out a way to squish it into the
gui. :slight_smile: In the meantime, as a workaround, I guess you know that you can
edit the query which populates the SB LHS. Just open the filter dialog,
click ‘custom filter’, then OK, and it should be obvious after
that. -John


#8

I realize this isn’t the beta group, but your request will be in the next
beta. If you have Toad 10.5 installed, you can get the beta here:
http://toadfororacle.com/beta.jspa -John


#9

I realize this isn’t the beta group, but your request will be in the next
beta. If you have Toad 10.5 installed, you can get the beta here:
http://toadfororacle.com/beta.jspa -John


#10

I opened a describe objects window for a table, then clicked on the filter icon.
Then I moved my focus outside of Toad. Now when I click on Toad the filter
window flashes then disappears behind the descriibe objects window. I’ve tried
alt+tab to see if I could get it to come forward, but no luck and I can’t use
anything else in Toad because it’s waiting for the filter window to be answered.
Any suggestions?

On 5/7/2010 6:01 PM, David A. Hicken wrote:

It would be a nicety to have one of the feature options in the User list
of the Schema Browser to only show those users who own objects. I know
that is available in the Export (or Datapump?) wizard, but it would be a
nice addition to the Schema Browser.

I'm just sayin'...

--
--
David A. Hicken
UtahToad at gmail dot com
---------- Kiva.org - Make a Small Loan. Make a Big difference.
'Tis always morning somewhere in the world.
--Richard Henry Horne

#11

It is already there see OPTIONS=> Schema Browser=> left hand side


#12

Thanks for the report Wendy,

I can reproduce this in 10.6. It has been fixed in the beta.

-John