Object Window - limit accounts displayed

[Bradnam]

Some of our databases have hundreds of user accounts.
In the Objects window, I know you can limit the objects displayed via the use of filters; is there a way to limit the higher level drop-down list in this window (the one that initially defaults to "" so that only those accounts who own database objects are shown?

 

[Marco Kalter]

In version 9.0 you can specify a "User selector where clause" to limit the users displayed (Tools > Preferences > User Interface / Object Browser).

 

[Bradnam]

Thanks Marco - that worked a treat

 

[TomGen]

Would it be possible to filter users list to those currently connected?

 

[Marco Kalter]

If you have select privileges on the v$session view, then this should be possible:

username in (select username from v$session)

However, this query is executed only once when the list is first opened, so it will be a static list.