Limit Drop Down List of Users

[MikeG62]

Hi. The database I work on has an unusually high amount of users. Would it be possible to see only the single user I work on whe I log in? Can this be done with an Oracle query, or a menu in PLSQL Developer itself?

 

[Marco Kalter]

Can you let me know to which user list you are referring specifically?

 

[MikeG62]

Hi Marco,

I am referring to the Schema's, which is on the left hand side, under the heading Objects.

Thanks

 

[Maxmix]

MikeG2,
Try this:
Put in the textbox
Tools|Preferences|UserInterface|ObjectBrowser|UserSelectorWhereClause(for sys.all_users_view) a text like

username='USERSCOTT'

This method could reset your choice on each reconnect (meaning you will have to reselect your USERSCOTT every time you change the connection).

Alternatively, create new browser filter (Tools|DefineBrowserFilters), and in Where clause box, put the predicate

owner in ('USERSCOTT')

You could also make just created browser filter the default by checking corresponding option.