Trying to make some changes to our security profiles, so I want to start from a copy of our existing profile. However, when I try to save the copy with a new name, I get this error message: Method security already exists - The name or number must be unique
Query to determine which profile/class/method is problematic:
Select p.PROFILENAME, cl.Class_Name, m.MethodName
from oq.METHODSECURITY m1, oq.METHODSECURITY m2,oq.CLASSSECURITY cs,
oq.SECURITYPROFILE p, oq.ommethod m,oq.omclass cl
where m1.OMMETHOD_OI = m2.OMMETHOD_OI and
m1.CLASSSECURIT_OI = m2.CLASSSECURIT_OI
and m1.METHODSECURITYOI<m2.METHODSECURITYOI
and m1.CLASSSECURIT_OI = cs.CLASSSECURITYOI
and p.SECURITYPROFILEOI = cs.SECURITYPROF_OI
and cs.OMCLASS_OI = cl.omcloi
and m1.OMMETHOD_OI = m.mthdoi