Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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

Created: 11 Feb 2011 | 1 comment

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

Comments 1 CommentJump to latest comment

jharings's picture

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.

Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.