Symantec Management Platform (Notification Server)

 View Only
Expand all | Collapse all

Is there a report on security and permmisions that list the Right Click Functions In 7 NS?

  • 1.  Is there a report on security and permmisions that list the Right Click Functions In 7 NS?

    Posted Feb 11, 2011 02:08 PM

    1) I need to write a report that list all the security roles and the permmisions attached to them.  I found one core report but it is missing the "Right Click" Permmissions on it. 

     

    2) The second report I need is a list of all the users/AD groups that are attached to a specific security role.

     

    Does anyone have the sql for this ty of report? Or at least tell me the tables that this data is in?  I need it for a compliance review ASAP.

     

    thanks, J



  • 2.  RE: Is there a report on security and permmisions that list the Right Click Functions In 7 NS?

    Posted Feb 11, 2011 04:39 PM

    ItemAction is the right click options, and contains only guids. I tied that to the vitem table below:

    select vI.name, ia.ItemGuid
    from vItem vi
    join ItemAction ia on ia.ItemGuid = vi.Guid

    So, the issue I see is joining\linking this to the security permission\role privilege tables which are:

    SecurityRole
    SecurityPrivilegeTrustee
    SecurityPrivilege

    None of which appear to be associated to the item actions.