If I connect with the SCHEMA in which triggers are defined then I am able to view the list of triggers in the find DB objects.
But when I connect with my user id then it is only showing Packages/Procedure but not the triggers in which I am looking for a particular text.
Let me know if I am missing any particular ROLE/PRIVILEGE.
If I user PL/SQL Developer's find DB objects then I am able to see the trigger in which the searched text are found.
You need to view objects under the tree for the user/schema that owns the objects.
1. Open the 'other users' tab
2. find the user/schema that owns the trigger
3. open the tab for that user
4. open the tab for triggers
If you have privileges on that other user's triggers you should be able to view them.
I can view the code of Triggers defined in ABC schema but when I am trying to search for a string the search results are not showing the Triggers. On the other hand I am getting search results fine in PL/SQL developer.
What is PL/SQL developer?
This is me searching trigger source from User A across all other users...
If you want to test, try in a worksheet or in SQL*Plus this query
select * from ALL_SOURCE where UPPER(TEXT) like '%ON DATABASE%'
and type = 'TRIGGER';
it will work depending on how ALL_SOURCE is constructed for your user/priv level.
I ran this query and did not got the result.
select * from ALL_SOURCE where UPPER(TEXT) like '%ABC%' and type = 'TRIGGER';
But when I ran following query then I got the desired output.
select * from DBA_SOURCE where UPPER(TEXT) like '%ABC%' and type = 'TRIGGER';
Seems like SQL Developer uses ALL_SOURCE to find objects and other tool PL/SQL Developer by Quest uses DBA_SOURCE to search objects in the DB.
1 person found this helpful
yes, that's why the widget says 'ALL_SOURCE' in the search tree options
Not everyone has access to DBA views