I want to get all the trigges and SP's that uses the keyword USER
I tried the ff;
select * from systrigbody where data like "%USER%";
select a.procname,b.data from sysprocedures a,sysprocbody b
where a.procid = b.procid
and upper(b.data) like "%USER%"
and lower(a.procname) like "v3%"
I guess what I'm saying is can anyone suggest a better way of doing it.
Thanks,
balatong