Filtering the "Users"

[sumsar]

How do I create a filtered list of users?
I have a database with several hundreds of users, but I only want the "Users" folder to list the schema owners, in my case, users named 'P$.....'

Rasmus

 

[Marco Kalter]

This is not possible. You can only filter object types from the sys.all_objects view.

You can however create a user-defined folder and add the users you are interested in (right-click on selection of users, select "Add to folder", and select your newly created user folder).

 

[D.]

Hi Sumsar,

I do this with a filter I use - I had to create a new filter (AR Users). I only show users starting with 'AR' (AR%), and I also included the "locked" status to quickly show me which users are currenty locked. This displays with the invalid icon (a small red x on the icon). Would be nice to have a small padlock or something for this status but the red 'x' does just fine for me. Here's the WHERE clause I use in the filter :-

owner='DUMMY'
UNION
select user owner, 'USER' object_type, username object_name, decode(account_status,'LOCKED','INVALID','VALID') status
from dba_users
where username like 'AR%'

Hope this helps ....

Regards,
D.

 

[sumsar]

Thanks a lot D. This was just what I was looking for.