Version 9 -- Restricting list of available users

[Sehlat]

I'm a member of a group of users in our department, and all of them are of a form "SIS###". However, the "users" list in "Objects" shows all current oracle users for all groups. How do I build a filter which will restrict the "available" list to those in my department?

 

[Marco Kalter]

You can go to Tools > Preferences > User Interface / Object Browser, and restrict the users through the "User selector where clause for sys.all_users view" option. For example:

username like 'SIS%'

 

[Sehlat]

Worked perfectly. Thank you.

 

[Alexx]

Hello,

I set the list of the users as you said and it works. Nevertheless when I choose 'ALL USERS', in the Views/Triggers etc. lists I see the objects of all the users in the system, but not only filtered. Can I hide them somehow? We have many developers and they have many objects in their schemata.

Thank you.

 

[Marco Kalter]

You will need to use an Object Browser Filter for this. The User Selector merely limits the objects to the selected user. The Filter allows you to define any filter on the object owner, name, type, and any other column from the all_objects view.