A question on Find Database Objects

[SaKa]

Hi,
Is there a way to specify a list of database objects to search for in "Find Database Objects" please? I mean either as a SQL or a comma separated list kind.

I appreciate one can specify a Name with wildcards etc. But we need to find an alternative filter than the name itself.

My issue is all My databases have so many objects and we group objects by business functions. We keep the objects listed in tables per function and need a way to search by these groups otherwise each full database search takes a very long time.

Thanks in advance
Sak
[PLSD Version 12 64bit]

 

[Marco Kalter]

No, this is currently not possible. They would need to be filtered on owner or name.

 

[Bernhard S]

Maybe a workaround would be to have special limited access users given access only to database objects based on business functions.
Then you could use those limited access users for finding database objects in relevant subsets of your database only.

 

[Nicolas D.]

Another solution you may get to is to have your own plugin to do custom search.

We did build that feature on our end, our plugin offer functionality to search within our metadata model specifically, specific type of objects or content of specific tables based on defined criteria.
That way we have a search functionality that match our exact needs.