Help is required to create custom report on targets assinged roles and role assigned to administrato
Select R.ROLE_NAME,T.TARGET_NAME
from SYSMAN.MGMT_ROLE_GRANTS R,sysman.MGMT_USER_TARGETS U,sysman.mgmt_targets T
where T.TARGET_TYPE='oracle_database' and R.ROLE_NAME <> 'PUBLIC' and
R.GRANTEE=U.GRANTEE and U.TARGET_GUID=T.TARGET_GUID
ORDER BY 1,2;
Please help.