Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

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.