Enterprise Manager Generic (MOSC)

MOSC Banner

Help is required to create custom report on targets assinged roles and role assigned to administrato

edited Feb 7, 2013 7:03AM in Enterprise Manager Generic (MOSC) 2 commentsAnswered
I am trying to create the custom report on targets assinged roles and role assigned to administrator in OEM11g ,But there is no parent-child relationship with roles and targets tables. hence giving me wrong results.


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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center